Kings of Tallinn - Kings of Tallinn Summer Showdown 2023 - Live Coverage

0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0066 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-12-26' AND `url` = 'https://www.maineventtravel.com/live-reporting/tallinn_summer_showdown_555championship_2023/1D/updates' ORDER BY `views` DESC

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

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.0001 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'EUR'

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

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

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

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

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

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

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

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

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

0.0004 SECONDS:
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name` FROM `pages` LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id` WHERE `pages`.`active` = '1'

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

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

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

0.0003 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '24'

0.0286 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` = '76' AND `published` = 1

0.0300 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` = '77' AND `published` = 1

0.0289 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` = '78' AND `published` = 1

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

0.0281 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0065 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '80' AND `published` = 1

0.0280 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` = '81' AND `published` = 1

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

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

0.0062 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` = '79' 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` = '3533' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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` = '3533' ORDER BY `chip_change` DESC, `busted` ASC

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

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

The fourth and final opening flight was a turbo-charged affair featuring 20-minute blind levels instead of the 40 minutes boasted during the first three opening flights with 46 players bagging chips from the 85 entries.

Three players transformed their 30,000 opening stack into more than 100,000 and all three were from Lithuania with Vasilij Barna leading the way with 131,500, just 500 chips more than Ramunas Mika (131,000), and just 6,000 more than Vygerdas Jonikas (125,500). Barna was the chip lead during the first part of Day 1c before things began to fall apart but now heads to Day 2 with a healthy stack.

While all these stacks are miles behind overall chip leader Tobias Napel, who ended the action-packed Day 1c with 338,000.

Player	Chips	Big Blinds
Vasilij Barna	131,500	82
Ramunas Mika	131,000	82
Vygerdas Jonikas	125,500	78
Patrick Pfeiffer	91,000	57
Carl Lockmer	90,000	56
Tommy Olavi Piironen	87,000	54
Ari Varonen	83,500	52
Martin Piik	83,000	52
Tonis Viik	82,000	51
Thomas Haverstad	80,500	50
Adria Comas I Roura	78,500	49
Sarosh Mir	75,000	47
Ermo Kosk	71,500	45
Paul Koppe	71,000	44
Kim Anders Lindstrom	67,500	42
Alexander Aaneland	63,500	40
Per Kasten	62,500	39
Henri Antikainen	56,500	35
Kasparas Drazdauskas	56,500	35
Saara Ylianttila	55,000	34
Karlis Kreilis	53,000	33
Martin Muller	52,500	33
Johannes Hermann Tobbe	52,500	33
Jari Lahtinen	51,500	32
Martins Sulte	50,500	32
Andzej Zinkevic	49,500	31
Uku Valner	45,000	28
Aurimas Stanevicius	44,000	28
Leo Colin	41,500	26
Jussi Karpanen	41,000	26
Kent Roed	38,500	24
Romas Bassus	37,500	23
Tapio Vihakas	37,000	23
Christian Steinbo	35,000	22
Herli Olop	34,000	21
Ville Pohjalainen	34,000	21
Jonas Pedersen	31,500	20
Steponas Venckus	28,000	18
Markku Koplimaa	25,000	16
Edvinas Tarasevicius	24,500	15
Ranno Sootla	20,500	13
Edgars Beizaks	18,500	12
Amin Asikainen	17,000	11
Kaido Mikk	17,000	11
Vytautas Kacerauskas	11,500	7
Jukka Moisio	10,500	7

Browse

Useful Links

Browse

Useful Links

Subscribe to our newsletter