0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0114 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_1100_Main_Event/1a/updates'
ORDER BY `views` DESC
0.0003 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.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.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.0003 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.0005 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.0125 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.0009 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = '2024_KOT_1100_Main_Event'
0.0006 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '91'
0.0340 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0078 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '241'
AND `published` = 1
0.0350 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0082 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '245'
AND `published` = 1
0.0322 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0050 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '250'
AND `published` = 1
0.0252 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0074 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '251'
AND `published` = 1
0.0356 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0084 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '256'
AND `published` = 1
0.0276 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0054 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '263'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '91'
AND `name` = '1a'
0.0056 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '241'
ORDER BY `busted` ASC, `current_chips` DESC
0.0053 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` = '241'
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` = '10739'
ORDER BY `chip_change` DESC, `busted` ASC
0.0110 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10738'
ORDER BY `chip_change` DESC, `busted` ASC
0.0111 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10732'
ORDER BY `chip_change` DESC, `busted` ASC
0.0111 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10731'
ORDER BY `chip_change` DESC, `busted` ASC
0.0112 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10720'
ORDER BY `chip_change` DESC, `busted` ASC
0.0112 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10712'
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` = '10707'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10704'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10698'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10691'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10687'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10682'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10673'
ORDER BY `chip_change` DESC, `busted` ASC
0.0098 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10672'
ORDER BY `chip_change` DESC, `busted` ASC
0.0109 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10667'
ORDER BY `chip_change` DESC, `busted` ASC
0.0111 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10657'
ORDER BY `chip_change` DESC, `busted` ASC
0.0109 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10655'
ORDER BY `chip_change` DESC, `busted` ASC
0.0109 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10643'
ORDER BY `chip_change` DESC, `busted` ASC
0.0090 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10641'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10634'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10620'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10616'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10613'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10607'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10606'
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` = '10593'
ORDER BY `chip_change` DESC, `busted` ASC
0.0109 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10595'
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` = '10588'
ORDER BY `chip_change` DESC, `busted` ASC
0.0109 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10586'
ORDER BY `chip_change` DESC, `busted` ASC
0.0110 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10582'
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` = '10580'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10506'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '241'
ORDER BY `busted` ASC, `current_chips` DESC
0.0048 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` = '241'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10739'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10738'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10732'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10731'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10720'
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` = '10712'
ORDER BY `chip_change` DESC, `busted` ASC
0.0107 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10707'
ORDER BY `chip_change` DESC, `busted` ASC
0.0110 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10704'
ORDER BY `chip_change` DESC, `busted` ASC
0.0111 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10698'
ORDER BY `chip_change` DESC, `busted` ASC
0.0081 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10691'
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` = '10687'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10682'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10673'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10672'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10667'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10657'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10655'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10643'
ORDER BY `chip_change` DESC, `busted` ASC
0.0102 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10641'
ORDER BY `chip_change` DESC, `busted` ASC
0.0109 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10634'
ORDER BY `chip_change` DESC, `busted` ASC
0.0109 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10620'
ORDER BY `chip_change` DESC, `busted` ASC
0.0109 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10616'
ORDER BY `chip_change` DESC, `busted` ASC
0.0109 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10613'
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` = '10607'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10606'
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` = '10593'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10595'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10588'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10586'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10582'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10580'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10506'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '241'
ORDER BY `busted` ASC, `current_chips` DESC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '245'
ORDER BY `busted` ASC, `current_chips` DESC
0.0056 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '251'
ORDER BY `busted` ASC, `current_chips` DESC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '256'
ORDER BY `busted` ASC, `current_chips` DESC
0.0053 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '263'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2351
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.
Day 1a of Kings of Tallinn 2024 Ended Level: 8 Blinds: 500/1,000 Ante: 1,000
Sleeping Beauty Leads Kings of Tallinn Main Event Posted Wednesday 28th February, 2024 at 19:54(UTC+0) by Jason Glatzer
Lithuania's Christian Rysgaard earned the nickname "Sleeping Beauty" last night after he took a nap during the dinner break in penultimate day of the €555 Championship thinking the day was over. He had the chip lead at the break and somehow survived nearly four full levels until he made it back thanks to his friend noticing the blog and waking him up.
Rysgaard did his best yesterday to make a run but fell short of punching his ticket to the final day near the end of the evening.
Meanwhile, during the final break today, Rysgaard sat on 72,000 in chips on Day 1a of the 2024 Kings of Tallinn €1,100 Main Event, and we joked that taking a nap now wouldn't be as bad.
It turns out, it wouldn't have been the best situation, as Rysgaard made a run during the final two blind levels to catapult his stack to 304,300 to take the Day 1a chip lead.
Meanwhile, United Kingdom's Maximilian Sanders visited Tallinn during the inaugural WSOP Circuit in September. He is likely glad he made the return trip to one of the most fun places to enjoy poker throughout the world as he bagged up 203,900. While this is a far cry from what Rysgaard accomplished while he was awake, he was the only other player to advance with more than 200,000 in chips.
Sweden's Wissam Polus, Lithuania's Laurynas Ceriauskas, and Estonia's Kaido Mikk round out the top five players for the day.
Many other big names found a bag including Super High Roller Paul Newey, Jussi "PottiJussi" Mattila, Kings of Tallinn Summer Showdown Main Event runner-up Phil Gross, Estonia grassroots poker supporter and former Head of Marketing at OlyBet and Olympic Park Casino poker manager Herli Olop, Rauno "Estonian Jesus" Tahvonen, and 2023 EPT Paris final tablist Henri Kasper all found bags on Day 1a.
The €1,100 Main Event is well on its way to decimating its €500,000 guarantee. Day 1a attracted a huge crowd of 238 entries to add €231,240 into the prize pool with 87 players finding a bag into Friday's Day 2.
The action resumes for Day 1b at noon on Thursday. Stay tuned to see whether the chip lead amassed by Christian "Sleeping Beauty" Rysgaard holds up. The final turbo opening flight takes place tomorrow night at 9 p.m. making tomorrow's leap year day an action-packed one for the 2024 Kings of Tallinn Main Event at Olympic Park Casino and the Hilton Tallinn Park.
Players can also late register and re-enter during the first four blind levels of Friday's Day 4. Check out all of the chip counts from the Day 1a by clicking on the 'Chip Counts' tab within our coverage.
Players Bagging Chips Posted Wednesday 28th February, 2024 at 18:51(UTC+0) by Jason Glatzer
Players are bagging and tagging their chips for Day 1a. We will update the full chip counts within the hour.
"It is a Bad Call, I am Not Stupid" Posted Wednesday 28th February, 2024 at 18:49(UTC+0) by Jason Glatzer
Level 8: 500/1,000 (1,000) Entries: 95/238
There was some action before Jon Gurrutxaga three-bet jammed around a starting stack. The action was on Gundars Zelcs when we caught up to the table with a decision to make having already committed 2,300 to the pot.
"I don't want to end today with a short stack," Zelcs said. "I call."
Jon Gurrutxaga: Gundars Zelcs:
"I folded an ace," Phil Gross said who was also at the table.
Despite Gross likely having an ace, there were at least two more left in the deck.
An ace popped up on the board and Gurrutxaga was on the rail.
Gross and Zelcs were having a friendly chat where Gross was questioning why he called.
"It was a bad call, I am not stupid," said Zelcs. "I wanted some chips in my bag."
Player
Chips
Progress
Gundars Zelcs
80,000
50,000
Jon Gurrutxaga
0
0
Set of Sixes for Mjelstad Posted Wednesday 28th February, 2024 at 18:20(UTC+0) by Jason Glatzer
Level 8: 500/1,000 (1,000) Entries: 100/238
Niclas Mjelstad jammed the river for around a pot-sized bet with the on the board. Visa Kiviharju tanked for several minutes until he snap-called off his stack of a bit less after a player called time.
Mjelstad turned over the for a set of sixes and Kiviharju mucked his hand. Even though it was an all-in and a call, the we will never know what Kiviharju's cards were as they were quickly buried into the deck.
Player
Chips
Progress
Niclas Mjelstad
100,000
70,000
Visa Kiviharju
0
0
Sleeping Beauty Wakes Up Posted Wednesday 28th February, 2024 at 18:09(UTC+0) by Jason Glatzer
Level 8: 500/1,000 (1,000) Entries: 107/237
We dubbed Lithuania's Christian Rysgaard last night as Sleeping Beauty. This is because had the chip lead before the dinner break during last night's penultimate day of the €555 Championship with 45 players left only for his seat to be empty when the action resumed.
Several people in the Lithuanian poker community tried to get in touch but had no luck.
"Ah, that was a good nap," Rysgaard said as he came back nearly 3 hours late after missing nearly four blind levels.
We learned after the end of the day from Rysgaard that his friend was reading the blog and managed to wake him up. Rysgaard said he intentionally went to sleep because he thought the day was over.
He came back and made a small run at it despite losing a majority of his stack before bowing out just shy of advancing to today's final day.
Perhaps that was all meant to be. We caught up with Rysgaard on the break when he had 72,000 in chips.
"It wouldn't be too bad this time if I took a nap," Rysgaard joked.
It is a good thing Rysgaard opted to play as he has been on a roll since the break and appears to hold the chip lead with 260,000 in chips. It isn't every day that a player achieves the overall chip lead in two separate big events in the same festival, so that is at least one check box marked off.
We wish Rysgaard the best of luck. He took everything in stride yesterday and was in incredible spirits today even before he had a big stack.
Meanwhile, a welcome back to Finland's Jussi Mattila who arrived today and hopped into the Main Event.
Player
Chips
Progress
Christian Rysgaard
260,000
230,000
Jussi Mattila
30,000
0
Final Day 1a Blind Level Begins Posted Wednesday 28th February, 2024 at 17:53(UTC+0) by Jason Glatzer
Level 8: 500/1,000 (1,000) Entries: 107/237
The blinds have just increased to 500/1,000 with a 1,000 big blind ante.
"This is the final blind level of the evening," the floor announced.
The clock will be stopped with a few minutes left near the end of Day 1a when the floor will randomly determine the number of hands each table still needs to play.
This same blind level will be repeated again on Day 2, giving Day 2 entries a 30 big blind stack to start the day off with.
Meanwhile, the €555 Championship has been heads-up between Finland's Mikko Ylämäki and Lithuania's Andrius Bielskis (pictured below) for some time with the short stack doubling time and time again. The blog for this event provides plenty of updates on the biggest hand.
17:48 (UTC+0)
Start of Level 8 Blinds: 500/1,000 Ante: 1,000
Silencov Out-Flips Arouso Posted Wednesday 28th February, 2024 at 17:38(UTC+0) by Jason Glatzer
Level 7: 400/800 (800) Entries: 114/237
Andrei Silencov opened for 1,700 from under the gun. Herli Olop (pictured below), who last night won a a stylish Kings of Tallinn cap autographed by an Estonian musician after he busted him in the Celebrity Special last night, called from the cutoff before Totti Arouso three-bet jammed for around 20,000.
Silencov four-bet shoved for slightly more than a starting stack and Olop folded.
Totti Arouso: Andrei Silencov:
Arouso was out of chips for Silencov to win the hand after he bricked the board.
Player
Chips
Progress
Herli Olop
107,000
77,000
Andrei Silencov
60,000
30,000
Totti Arouso
0
0
Sanders Wins Massive Pot With Aces Vs. Kings Posted Wednesday 28th February, 2024 at 17:22(UTC+0) by Jason Glatzer
Level 7: 400/800 (800) Entries: 126/236
We were walking past Table 14 when a pot of around 200,000 was being passed onto Maximilian Sanders (pictured below) with aces tabled.
We learned later that Georgi Abuladze called a four bet with kings, before calling another small bet on a blank flop by Sanders. Sanders bet small again on turn before calling a jam by Abudladze. No love came for Abulzadze on the river and he was down to just a couple of chips.
Abuladze donated these small chips as well and will need to re-enter for a chance at Main Event glory.
Player
Chips
Progress
Maximilian Sanders
225,000
127,000
Georgi Abuladze
0
0
Kulanurk Wins Flip With Big Slick Against Larsen Posted Wednesday 28th February, 2024 at 17:12(UTC+0) by Jason Glatzer
Level 7: 400/800 (800) Entries: 127/235
Artur Kulanurk (pictured below) four-bet jammed from middle position and was called by Thomas Larsen, who three-bet the button, leaving Kularnurk at risk.
Artur Kulanurk: Thomas Larsen:
Kulanurk won the flip but didn't pull ahead until his king connected on the river with the rolling out on the board.
Player
Chips
Progress
Thomas Larsen
45,000
15,000
Artur Kulanurk
40,000
10,000
Top Pair Good for Dirmantas Posted Wednesday 28th February, 2024 at 17:05(UTC+0) by Jason Glatzer
Level 7: 400/800 (800) Entries: 129/231
Ragnar Toompere checked the board after the river before Gedminas Dirmantas jammed for 7,500 into a pot of nearly 18,000.
Toompere confirmed the amount of the jam before he tanked for about 30 seconds. Eventually he made the call but tried to muck his cards after Dirmantas turned over the for the top pair and top kicker.
The dealer pushed the cards back to Toompere and asked him to show what he had to the table. He was one pair shy with and the pot officially was awarded to Dirmantas.
Player
Chips
Progress
Ragnar Toompere
45,000
15,000
Gediminas Dirmantas
35,000
5,000
Big Stacks at Break Posted Wednesday 28th February, 2024 at 16:49(UTC+0) by Jason Glatzer
Player
Chips
Progress
Yaniv Peretz
152,000
23,000
Mindaugas Kriauciunas
137,900
107,900
Jon Martinez
135,000
31,000
Adria Comas I Roura
130,000
100,000
Kris Tikka
130,000
40,000
Ignas Navickas
126,000
38,500
Steven Tool
125,900
45,900
Mathias Siljander
121,100
91,100
Wissam Polus
114,700
84,700
Peter Jaksland
110,000
80,000
Vytautas Laurinaitis
110,000
40,000
Maximilian Sanders
98,000
68,000
Laurynas Cerniauskas
91,300
27,000
16:47 (UTC+0)
Start of Level 7 Blinds: 400/800 Ante: 800
Break Time Posted Wednesday 28th February, 2024 at 16:37(UTC+0) by Jason Glatzer
Players are on their final break of Day 1a. The blinds will increase to 400/800 (800) before heading into 500/1,000 (1,000).
After these two levels, surviving players will bag their stacks into Friday's Day 2.
Tikka Dusts Off Tarmi with Quad Cowboys Posted Wednesday 28th February, 2024 at 16:21(UTC+0) by Jason Glatzer
Level 6: 300/600 (600) Entries: 135/221
Roope Tarmi got his short stack in with a three-bet jam and was quickly called by Kris Tikka.
Roope Tarmi: Kris Tikka:
Tarmi was behind but he ran into a monster as Tikka won the hand with four of a kind on the board.
While the photo below is from Tikka at the WSOPC Tallinn last year, he is wearing the same outfit today and looks very similar.
"I decided to intentionally wear the same as I did during the WSOP Circuit," Tikka explained with a big smile.
Player
Chips
Progress
Kris Tikka
90,000
60,000
Roope Tarmi
0
0
Set of Ducks for Peretz Posted Wednesday 28th February, 2024 at 16:07(UTC+0) by Jason Glatzer
Level 6: 300/600 (600) Entries: 149/212
Long-time poker grinder Yaniv Peretz has made a few trips up to Estonia from his home in Latvia over the years and is back for the 10th edition hoping to carve his name into the tour's Main Event history books.
Peretz already had a big stack and just added a bit more in the following hand:
Peretz paused for a few moments with around a starting stack already in the pot and the on the board before he jammed his huge stack.
Erki Andressoo went into the tank for more than a minute before he called off his stack of 16,000. Peretz turned over the for a set of ducks. Andressoo pushed his cards forward face down. The dealer flipped them over to show the table Andressoo's .
Player
Chips
Progress
Yaniv Peretz
175,000
145,000
Erki Andressoo
0
0
Meet Queens of Tallinn Host & FLIP Founder Daiva "Baltic Blonde" Byrne Posted Wednesday 28th February, 2024 at 15:48(UTC+0) by Jason Glatzer
Only Quads for Laurinaitis Posted Wednesday 28th February, 2024 at 15:46(UTC+0) by Jason Glatzer
Level 6: 300/600 (600) Entries: 149/212
Vytautas Laurinaitis owned one of the bigger stacks at break. He just added some chips compliments of Tarmo Tammel, who for many years, leads the leaderboard on the most cashes in international tournaments at Olympic Park Casino with 74 entering this festival according to The Hendon Mob.
Laurinaitis fired out for 15,000 into a pot of around 20,0000 with the on the board. Tammel tanked for several minutes even saying out loud what hands Laurinaitis might have.
Eventually, Tammel called but didn't show his cards as Laurinaitis couldn't be beat tabling for quad nines.
"Nice hand," Tammel said to Laurinaitis. "Very nice hand."
Player
Chips
Progress
Vytautas Laurinaitis
150,000
40,000
Tarmo Tammel
10,000
20,000
15:34 (UTC+0)
Start of Level 6 Blinds: 300/600 Ante: 600
Full House for Tool to Felt Merivirta Posted Wednesday 28th February, 2024 at 15:12(UTC+0) by Jason Glatzer
Level 5: 200/500 (500) Entries: 146/202
Steven Tool, who a few weeks ago was battling at the Vilnius Ace Breaker alongside fellow Estonian Urmo Velvelt, jammed for about 20,000 into a pot of more than double that with the on the board. Jyri Merivirta went into the tank for a few moments before he called.
Tool turned over the for a full house and Merivirta pushed his cards forward face down. The dealer immediately turned them over to show Merivirta was ahead preflop with but his two pair wound up not being enough by the end of the hand.
Player
Chips
Progress
Steven Tool
80,000
50,000
Jyri Merivirta
0
0
More Than 200 Entries on Day 1a Posted Wednesday 28th February, 2024 at 15:08(UTC+0) by Jason Glatzer
Level 5: 200/500 (500) Entries: 145/201
The €500,000 guarantee slapped on the €1,100 Main Event appears to be a footnote as it is inevitable that the guarantee with be smashed with the Day 1a field recently popping over 200 entries.
Super High Roller Paul Newey (pictured below), Kaido Mikk, Audrius Navickas, Herli Olop, and Neeme Org are among the faces noticed in the field.
Player
Chips
Progress
Neeme Org
30,000
0
Herli Olop
30,000
0
Audrius Navickas
30,000
0
Kaido Mikk
30,000
0
Paul Newey
30,000
0
Inaugural KoT Main Event Champ Ranno Sootla Has Some Work to Do Posted Wednesday 28th February, 2024 at 14:59(UTC+0) by Jason Glatzer
Level 5: 200/500 (500) Entries: 146/199
Ranno Sootla and the Kings of Tallinn were both relatively unknown when the festival launched in 2015. Now, Sootla has a poker resume that most can only dream about with both a WSOP bracelet and a WSOP Circuit Tallinn ring among many other big wins.
Sootla was already a known local player, but began to get some international attention after he defeated a field of 140 entries to win the €37,730 top prize. Sootla is back in action today, but hasn't gotten much going yet with just 20,000 of his 30,000 starting stack remaining. This is still better than 50+ other entries who witnessed their chips vanish into their opponent's stacks.
Video Recap From Day 5 Posted Wednesday 28th February, 2024 at 14:49(UTC+0) by Jason Glatzer
Check out the video highlights below from Day 5 of the 2024 Kings of Tallinn powered by OlyBet at Olympic Park Casino and the Hilton Tallinn Park:
Soft Celebration for Tsouloftas Posted Wednesday 28th February, 2024 at 14:46(UTC+0) by Jason Glatzer
Level 5: 200/500 (500) Entries: 149/196
We have seen enough from Cyprus's Georgios Tsouloftas (pictured below) that he isn't afraid to fire multiple bullets in an event if needed. He saved at least one bullet after winning a flip against Patrikas Aglinskas to get back above starting stack as follows.
Tsouloftas four-bet jammed for 15,800 and was called by Aglinskas who three-bet from the blinds.
Georgios Tsouloftas: Patrikas Aglinskas:
"Yes!" said Tsouloftas in a voice slightly higher than a whisper after his snowmen held on the board.
Player
Chips
Progress
Patrikas Aglinskas
40,000
10,000
Georgios Tsouloftas
33,000
3,000
Big Stacks at Break Posted Wednesday 28th February, 2024 at 14:34(UTC+0) by Jason Glatzer
Spanish poker refugee living in Estonia Jon Martinez led the way at the break with an impressive stack of 166,600. Check out the other big stacks at the break below:
Player
Chips
Progress
Jon Martinez
166,000
136,000
Laurynas Cerniauskas
118,300
6,700
Vytautas Laurinaitis
110,000
80,000
Reinis Zageris
105,000
75,000
Ignas Navickas
87,500
57,500
Igor Pihela Sr.
80,200
50,200
Jonatan Fors
80,000
50,000
Eduards Rakuss
79,900
49,900
Juha Elo
79,300
49,300
Tapio Aaltonen
78,000
48,000
Edgaras Kausinis
78,000
48,000
Ville-Tapio Mesirahta
30,000
0
14:34 (UTC+0)
Start of Level 5 Blinds: 200/500 Ante: 500
Break Time Posted Wednesday 28th February, 2024 at 14:21(UTC+0) by Jason Glatzer
Players are on a 15-minute break. The floor announced that opening flights consisting of one pineapple hold'em flip will be taking place for the €150 OlyBet Flip & Go Mystery Bounty in the main hall.
Opening flights will run all week long with players hoping to be the one to pull the €10,000 top mystery bounty guaranteed in this event.
Top Two Good for Cerniauskas Posted Wednesday 28th February, 2024 at 14:19(UTC+0) by Jason Glatzer
Level 4: 200/400 (400) Entries: 147/193
There was around 40,000 in the pot when Yuval Rosenberg jammed for about 20,000 with the on the board after the river. Laurynas Cerniauskas (pictured below) snap-called and turned over the for the top two pair.
Rosenberg attempted to muck his cards, but as it was an all-in and a call, the cards were exposed to show Rosenberg was attempting to make a move on the river with .
Player
Chips
Progress
Laurynas Cerniauskas
125,000
95,000
Yuval Rosenberg
0
0
Nearly 200 Entries Midway Through Day 1a Posted Wednesday 28th February, 2024 at 14:10(UTC+0) by Jason Glatzer
Level 4: 200/400 (400) Entries: 151/193
The coverage of the Main Event has just kicked off with the final table of the €555 Championship underway in full force. Frank Visser is providing the written updates at OlyBet.tv while you can also check out the stream of the final table with hole cards exposed at OlyBet.tv as well.
Day 1a of the €500,000 guaranteed 2024 Kings of Tallinn €1,100 Main Event has already drawn 193 entries after starting the day with 50 players in their seats.
Feras Abid, Egidijus Digrys, Jimmy Dewerdt, Kairit Leibold, Roope Tarmi, Jonatan Fors, Vadim Guk, former Kings of Tallinn Main Event champion Matias Knaapinen, and Luca Beretta are among the early entries.
The second break of the day is coming in about 10 minutes, after which time we will update you on the biggest stacks from around the room.
Player
Chips
Progress
Jimmy Dewerdt
30,000
0
Luca Beretta
30,000
0
Matias Knaapinen
30,000
0
Vadim Guk
30,000
0
Jonatan Fors
30,000
0
Roope Tarmi
30,000
0
Kairit Leibold
30,000
0
Egidijus Digrys
30,000
0
Feras Abid
30,000
0
14:03 (UTC+0)
Day 1 of Kings of Tallinn 2024 Started Level: 4 Blinds: 200/400 Ante: 400
Welcome to the Kings of Tallinn Main Event Posted Wednesday 28th February, 2024 at 09:05(UTC+0) by Jason Glatzer
Welcome to the 10th version of the Kings of Tallinn €1,100 Main Event at Olympic Park Casino.
The event provides plenty of play with players starting with 30,000 in chips from Feb. 28 to March 3. The only exception is Thursday evening's third and final opening flight which isn't quite a turbo but does play out faster with 30-minute blind levels. Each opening flight boasts eight levels with late registration still open for the first four blind levels of Day 2.
Our coverage of the Main Event will begin about 30 minutes after the final table is reached in the €555 Championship. There will be 13 players remaining when the action in this prestigious event resumes at 12:30 p.m. You will be able to watch the action of the feature table and final table live-streamed on a 30-minute delay at OlyBet.tv and also follow along the biggest hands in our dedicated blog for this event.
In the meantime, we wish the best of luck to everyone battling it out in the Main Event. Cards will be in the air at 12:00 and we will pick up on the action during the middle of the day.
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.