0.0005 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

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

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

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

0.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.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.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.0005 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.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.0043 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` = 'tallinn_summer_showdown_555championship_2023'

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

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

0.0286 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0061 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.0061 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '78'
AND `published` = 1

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

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

0.0385 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0099 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '81'
AND `published` = 1

0.0007 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '24'
AND `name` = '1A'

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

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

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

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

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

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

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

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

0.0108 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.0007 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 €555 Championship Live Reporting - Day 3
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 37 Current Day 3
Blinds 200,000/400,000 Ante 400000
Entries 573 Remaining 1
Prize Pool (EUR) €269,310 First Prize (EUR) €56,900
Day 1A Day 1B Day 1C Day 1D Day 2 Day 3
Live Updates Chip Counts Structure Gallery Payouts
1 New Update - Click to refresh
Live Updates - Day 1A
Final Day 1a Chip Counts Posted Monday 24th July, 2023 at 13:28(UTC+2) by Jason Glatzer

Day 1a attracted 148 entries with 52 players surviving. Check out the end-of-the-day chip counts below:

Name Chips Big Blinds
Roope Tarmi 257,000 161
Tanel Tammela 186,500 117
Steven Seller 160,500 100
Anders Auset 150,000 94
Anton Pereyaslov 147,000 92
Sondre Stormyr 140,000 88
Erikas Gordejevas 135,500 85
Bo Berggren 128,500 80
Igor Pihela 127,000 79
Dainius Kudarauskas 110,000 69
Fabian Bartuschk 109,500 68
Erik Int 107,000 67
Yevhen Roshchebak 104,500 65
Nikita Padisaar 102,500 64
Henrik Veldhoen 102,000 64
Jaana Kindsigo 100,000 63
Ingus Arajs 97,500 61
Gytis Bernatavicius 97,000 61
Mihhail Skola 95,500 60
Lucas Miguel Cravero 92,500 58
Dmitri Dudakov 92,000 58
Bartosz Wesolek 87,500 55
David Lopez De Miguel 84,000 53
Joshua Dittmann 83,500 52
Henri Schalin 80,000 50
Inigo Robles 80,000 50
Allan Pukk 77,500 48
Risto Pärnat 75,000 47
Hendrik Diegenant 73,000 46
Rauno Remmel 70,000 44
Enea Subashi 67,500 42
Rikard Relander 66,500 42
Ignacio Garrido 66,000 41
Rene Krause 64,000 40
Rait Kaimer 61,500 38
Hyunsil Park 60,500 38
Marko Harkonen 59,000 37
Marius Morel 56,500 35
Andrius Bielskis 55,000 34
Mikko Ylamaki 55,000 34
Patrick Schratz 54,000 34
Erik Borkvik 53,500 33
Orjan Skommo 51,000 32
Ranel Käsi 48,500 30
Kristaps Renga 43,000 27
Oskar Ojaveer 40,000 25
Andrey Koks 39,500 25
Aleksandr Kuperman 39,000 24
Robert Rohr 34,500 22
Reda Ighanoussene 29,000 18
Tarmo Tammel 25,000 16
Rein Ingland 22,000 14
Welcome to the Kings of Tallinn Summer Showdown €555 Championship Posted Friday 21st July, 2023 at 12:22(UTC+2) by Jason Glatzer

Welcome to the 2023 Kings of Tallinn Summer Showdown at the plush surroundings at Olympic Park Casino and the adjacent Hilton Tallinn Park for an exciting 10 days of poker from July 21-30.

The festival boasts 53 numbered events along with cash games running 24 hours a day in a variety of poker variants and stakes.

Our coverage will begin July 24 with Day 1c of the €555 Championship while providing updated end-of-the-day chip counts of the two other opening flights, similar to what will be reported for Day 1d. The coverage will then continue for two more days for Day 2 and Day 3 until a winner is crowned on July 26.

The first two opening flights attracted 217 entries, a figure we expect to more than double with 77 players punching their ticket into Tuesday's Day 2.

Stay tuned to see who will win the €555 Championship and other events at the 2023 Kings of Tallinn Summer Showdown.

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.