Kings of Tallinn - Kings of Tallinn 2024 - Live Coverage

0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0078 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-22' AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_555_Champ/1D/updates' ORDER BY `views` DESC

0.0008 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/2024_KOT_555_Champ/1D/updates', 1, '2024-11-22')

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

0.0001 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.0004 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.0004 SECONDS:
SELECT * FROM `settings` JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com'

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

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

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

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

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

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

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

0.0004 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '90'

0.0276 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0066 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '224' AND `published` = 1

0.0288 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0073 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '230' AND `published` = 1

0.0282 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0062 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '231' AND `published` = 1

0.0274 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0064 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '236' AND `published` = 1

0.0315 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0075 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '237' AND `published` = 1

0.0285 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0069 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '240' AND `published` = 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

The final opening flight of the Kings of Tallinn €555 Championship in Day 1d attracted 77 entries with 40 players advancing after nine blind levels of 25 minutes each.

Estonia's Martti Keel (pictured above) bagged up 183,700 and will just be behind Sweden's Bengt-Anders Johnsson, who bagged the overall chip lead on Day 1c with 212,600.

Keep your eyes peeled about whether the €555 Championship will establish a new Kings of Tallinn record which leading up to the event stood at the 573 entries attracted during the 2023 Kings of Tallinn Summer Showdown won by Estonia's Maikel Homin for €56,900. The current version of this event is already up to 528 entries for a €242,880 prize pool along with 150 survivors after the four opening flights.

These figures will grow with late registration remaining open during the first three 40-minute blind levels on Tuesday's Day 2 with the action kicking off at noon.

Check out the full chip counts for Day 1d and stay tuned for the Day 2 seat draw.

Player	Country	Chips	Big Blinds
Martti Keel	EST	183,700	153
Dmitrijs Arsuns	LVA	124,600	104
Henri Antikainen	FIN	106,800	89
Rasmus Lundstrom	FIN	105,400	88
Juan Carlos Vecino Deunas	ESP	105,300	88
Roope Tarmi	FIN	90,000	75
Meelis Meliste	EST	86,300	72
Niklas Gjersvold	NOR	83,300	69
Jani Vilmunen	FIN	78,600	66
Phillip Mazan	SWE	78,200	65
Adrians Imsa	LVA	74,600	62
Doroslav Rasiukevic	LTU	68,900	57
Lukas Kviecinskas	LTU	67,500	56
Ville Lonngren	FIN	63,500	53
Reese Smith	GBR	63,000	53
Mihn Thang Ngo	FIN	62,800	52
Toni Sarkama	FIN	60,500	50
Richard Koppel	EST	57,800	48
Jukka Moisio	FIN	53,400	45
Eduards Rakuss	LVA	51,100	43
Joel Ylismaki	FIN	48,700	41
Oleksandr Tarashevskyi	UKR	48,400	40
Mattias Hansen	DNK	48,000	40
Sjoerd Nikkels	FRA	47,700	40
Herli Olop	EST	47,300	39
Irmantas Bzeskis	LTU	39,100	33
Tomi Arponen	FIN	37,900	32
Rain Heeringas	EST	37,200	31
Dmitrijs Rizovs	EST	35,600	30
Juha Kinnunen	FIN	33,800	28
Semir Natzi	GRC	33,800	28
Konsta Heikkilä	FIN	32,000	27
Jarkko Suokas	FIN	28,700	24
Max Rotko	FIN	26,600	22
Knut Trulsen	NOR	26,600	22
Masse Mirza	EST	25,000	21
Nicolas Courbin	FRA	22,400	19
Roope Holma	FIN	21,100	18
Adrian Espinosa	ESP	19,100	16
Viktor Blinov	EST	11,600	10
Eli Malca	NOR	4,400	4

Browse

Useful Links

Browse

Useful Links

Subscribe to our newsletter