0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0836 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/24/79/chips'

0.0004 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.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '24'

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

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

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

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

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

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

0.0134 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.1567 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.0056 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.0177 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.0142 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.0058 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

Chip Counts - Day 1D

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