0.0005 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0109 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/25/75/payouts'
ORDER BY `views` DESC

0.0007 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/25/75/payouts', 1, '2024-11-22')

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` = '25'

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

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

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

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

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

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

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

0.0067 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.0058 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.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` = '3787'
ORDER BY `chip_change` DESC, `busted` ASC

0.0269 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.0064 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
Translate
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 200,000
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
Payouts
Place Player Prize (EUR)
1 Kai Lehto €108,260
2 Phil Gross €72,700
3 Urmo Velvelt €49,300
4 Ville Keranen €34,900
5 Tarmo Tammel €25,600
6 Mikael Haapaniemi €19,300
7 Tomi Arponen €13,400
8 Magnus Pukk €10,100
9 Jakob Linden €7,700
10 Tapio Aaltonen €6,300
11 Ilya Nikiforov €5,300
12 Anatoly Filatov €5,300
13 Juho Heiska €4,500
14 Feras Abid €4,500
15 Karolis Kutkauskas €4,500
16 Siim Suviste €4,500
17 Roberts Rumba €3,900
18 Vygerdas Jonikas €3,900
19 Vlads Dolgilevics €3,900
20 Guillermo Gordo Cifuentes €3,900
21 Igor Pihela Jr €3,900
22 Nick Penning €3,900
23 Herli Olop €3,900
24 Hendrik Diegenant €3,900
25 Touko Berndtson €3,300
26 Patrick Schratz €3,300
27 Kristian Larsson €3,300
28 Anna-Mari Hursti €3,300
29 Joonas Helin €3,300
30 Edgars Beizaks €3,300
31 Jari Saviaho €3,300
32 Stefan Bittger €3,300
33 Lukas Rutkauskas €3,000
34 Yanis Sahli €3,000
35 James Noonan €3,000
36 Aleksi Naski €3,000
37 Christian Steinbo €3,000
38 Jaana Kindsigo €3,000
39 Juan Carlos Vecino Duenas €3,000
40 Samuli Hietala €3,000
41 Daniel Jullumstro €2,700
42 Jordi Baixas €2,700
43 Hein Haraldsen €2,700
44 Kasper Mellanen €2,700
45 Matias Arosuo €2,700
46 Andrei Mjagkov €2,700
47 Mauri Dorbek €2,700
48 Dmitrijs Kornevs €2,700
49 Keito Kaljulaid €2,400
50 Ranno Sootla €2,400
51 Anders Auset €2,400
52 Tero Kilkanen €2,400
53 Henri Schalin €2,400
54 Kasparas Klezys €2,400
55 Maksim Rusinov €2,400
56 Kaspar Laursoo €2,400
57 Kaido Mikk €2,200
58 Kristaps Deksnis €2,200
59 Harri Seppa €2,200
60 Espen Sandvik €2,200
61 Luiz Cruz €2,200
62 Sebastian Van Wonterghem €2,200
63 Ramunas Mika €2,200
64 Grantas Naujokas €2,200
65 Matias Kesanen €2,000
66 Jargo Alavali €2,000
67 Konstantin Arber €2,000
68 Kalle Parkkinen €2,000
69 Martin Piik €2,000
70 Julian Herold €2,000
71 Hyunsil Park €2,000
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.