0.0161 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.1614 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/24/79/updates'
ORDER BY `views` DESC

0.0104 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/24/79/updates', 1, '2024-07-27')

0.0097 SECONDS: 
SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, 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.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 `tour_stop_blogs`.`id` = '24'

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

0.1039 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0811 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '76'
AND `published` = 1

0.1905 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0192 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '77'
AND `published` = 1

0.1109 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0592 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '78'
AND `published` = 1

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

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

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

0.0151 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.0080 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.0577 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.0104 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.0074 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2084

    

Open Modal

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.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

Translate

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Eesti
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Nederlands
• Ελληνικά
• Русский

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 400,000

Entries 573 Remaining 1

---

Prize Pool (EUR) €269,310 First Prize (EUR) €56,900

Chip Leaders Day 3

1

Maikel Homin

17,200,000

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 1D

Lithuanians Dominate Day 1d Leaderboard Posted Tuesday 25th July, 2023 at 07:58(UTC+2) by Jason Glatzer

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