0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0028 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/summer_showdown_main_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.0001 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.0036 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` = 'summer_showdown_main_2023'

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

0.0293 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` = '75'
AND `published` = 1

0.0303 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` = '83'
AND `published` = 1

0.0499 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` = '85'
AND `published` = 1

0.0306 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` = '86'
AND `published` = 1

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

0.0296 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` = '92'
AND `published` = 1

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '25'
AND `name` = '1A'

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '75'
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_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '75'
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` = '3787'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '75'
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_id` = '75'
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` = '3787'
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` = '3495'
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` = '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 1A
Final Day 1a Chip Counts Posted Wednesday 26th July, 2023 at 20:30(UTC+0) by Jason Glatzer

Day 1a attracted a banner field of 188 entries with even more expected for Thursday's Day 1b. Just 75 players survived the eight one-hour blind levels. Finland's Feras Abid found himself in a familiar spot with the chip lead with 221,000 in chips with Jargo Alavali and Tapio Aaltonen also bagging more than 200,000.

Check out all of the chip counts from the end-of-Day 1b below:

Player Chips Big Blinds
Feras Abid 221,000 184
Jargo Alavali 213,000 178
Tapio Aaltonen 212,600 177
Karolis Kutkauskas 191,100 159
Magnus Pukk 171,400 143
Sebastian Van Wonterghem 168,800 141
Juan Carlos Vecino Duenas 163,800 137
Anna-Mari Hursti 151,700 126
Nils Linden 134,900 112
Tomi Tapani Arponen 117,100 98
Jan-Mikael Kesanen 106,700 89
Mark Metsla 105,500 88
Ermo Kosk 105,200 88
Henri Schalin 103,600 86
Adria Comas I Roura 103,300 86
Kai Lehto 101,300 84
Ivar Rühka 94,800 79
Henri Wagner 93,500 78
Georgi Abuladze 92,700 77
Tero Laurila 91,500 76
Maksim Rusinov 90,100 75
Jani Tuovinen 87,500 73
Jari Mahonen 84,000 70
Enea Subashi 82,400 69
Igor Pihela 79,200 66
Henning Gunnar Andre  79,000 66
Claudio Cecchi 76,300 64
Stephane Cordeille 75,600 63
Urmo Velvelt 75,300 63
Siim Suviste 74,000 62
Casimir Seire 73,900 62
Hendrik Diegenant 73,000 61
Grantas Naujokas 70,400 59
Aleksi Naski 67,400 56
Janne Nevalainen 67,400 56
Akseli Paalanen 67,000 56
Ignacio Garrido 66,500 55
Martin Piik 65,300 54
Jari-Pekka Juhola 64,400 54
Vladislav Senkevic 64,200 54
Kristian Larsson 62,100 52
Totti Arosuo 60,800 51
Jyrki Lampinen 59,200 49
Ivar Vendelin 58,100 48
Karlo Kivi 56,800 47
Niki Nurmisto 55,900 47
Vadims Milovs 50,200 42
Inigo Robles 49,300 41
Elias Vaaraniemi 45,700 38
Edgars Beizaks 45,500 38
Andres Aro 43,500 36
Matias Kesanen  41,100 34
Touko Berndtson 40,100 33
Stefan Bittger 38,700 32
Kaspars Butans 37,500 31
Kaido Mikk 36,800 31
Tonis Viik 34,600 29
Eetu Porkka 32,000 27
Patrick Schratz 30,000 25
Oskar Ojaveer 29,300 24
Stanislav Smeljov 28,900 24
Lars Nydegger 27,500 23
Julius Tiihonen 27,500 23
Silver Simulask 25,200 21
James Noonan 24,500 20
Alberto Gonzalez 24,000 20
Andrey Koks 21,200 18
Kalle Lindholm 21,000 18
Patrick Pfeiffer 21,000 18
Elias Suhonen 20,000 17
Yanis Sahli 18,300 15
Jose Koistinen 18,200 15
Artjoms Hromovs 16,400 14
Sergei Aleksejev 11,300 9
Eeti Loyttyniemi 8,300 7
Welcome to the Kings of Tallinn Summer Showdown Posted Wednesday 26th July, 2023 at 08:52(UTC+0) by Jason Glatzer

Welcome to the 2023 Kings of Tallinn Summer Showdown €1,100 Main Event at our flagship casino Olympic Park Casino and the adjacent Hilton Tallinn Park.

The Main Event boasts three opening flights with most of the event featuring one-hour blind levels with the exception of Thursday evening's Day 1c, which plays twice as fast with 30-minute blinds. Each opening flight will feature eight blind levels with breaks after every two levels. Players can late register and re-enter not only throughout all of the opening flights but also during the first two blind levels of Friday's Day 2.

Cards will be in the air at noon with surviving players expected to bag and tag before 9 p.m. in enough time to play events in the evening as well.

The trophy stayed home during the 2023 Kings of Tallinn a few months ago with Estonia's Priit Parmisto surging ahead to eventually become the last player standing after agreeing to a three-way deal with two Finnish players in Petteri Laiho and Antti Vetelainen. While Parmisto got most of the accolades, his €97,400 prize wasn't the biggest haul as Laiho had the chip lead when the deal was made to secure €102,500. This event attracted 716 entries for a €673,040 prize pool and we look forward to a massive prize pool this time around.

Our coverage today will be limited to the end-of-the-day chip counts as we focus on the conclusion of the €555 Championship. We will be on the floor for Day 1b with detailed reports.

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.