0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0142 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/100/234/payouts'

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

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

0.0283 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` = '233'
AND `published` = 1

0.0283 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` = '234'
AND `published` = 1

0.0284 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` = '244'
AND `published` = 1

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

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

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

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

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

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

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

0.0012 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2351
Translate
Kings of Tallinn 2024 Event #12: €555 Championship (Finnish) Live Reporting - Day 3
Kings of Tallinn 2024 - Live Reporting Event #12: €555 Championship (English) Event #29: €1,100 Main Event (English) Event #42: €5,000 High Roller (English) Event #49: €3,000 NLH (English) Event #3: €350 Kings of Tallinn Cup (Estonian) Event #12: €555 Championship (Estonian) Event #27: €150 Celebrity Event (Estonian) Event #29: €1,100 Main Event (Estonian) Event #42: €5,000 High Roller (Estonian) Event #49: €3,000 NLH (Estonian) Event #12: €555 Championship (Finnish) Event #29: €1,100 Main Event (Finnish) High Roller Events (Finnish)
Current Level 35 Current Day 3
Blinds 200,000/400,000 Ante 400,000
Entries 700 Remaining 1
Prize Pool (EUR) €329,000 First Prize (EUR) €65,360
Day 2 Day 1C Day 3
Live Updates Chip Counts Structure Gallery Payouts
1 New Update - Click to refresh
Payouts
Place Player Prize (EUR)
1 Mikko Ylämäki €58,835
2 Andrius Bielskis €49,875
3 Joonas Helin €27,900
4 Oscar Peleg €20,100
5 Jordi Baixas €15,200
6 Aleksandrs Krumins €11,250
7 Touko Berndtson €8,700
8 Matte Karjalainen €7,200
9 Knut Trulsen €5,890
10 Konsta Heikkilä €4,700
11 Svetozar Marinov €4,700
12 Jan-Mikael Kesänen €3,600
13 €3,600
14 €2,850
15 €2,850
16 €2,150
17 €2,150
18 €2,150
19 €2,150
20 €2,150
21 €2,150
22 €2,150
23 €2,150
24 €1,800
25 €1,800
26 €1,800
27 €1,800
28 €1,800
29 €1,800
30 Kevin Karenius €1,800
31 Jani Vilmunen €1,800
32 Jonatan Fors €1,600
33 €1,600
34 Roope Tarmi €1,600
35 €1,600
36 Juuso Oksanen €1,600
37 €1,600
38 Luka Sorainen €1,600
39 €1,600
40 €1,400
41 Ville Turja €1,400
42 Akseli Paalanen €1,400
43 €1,400
44 €1,400
45 €1,400
46 Kasper Mellanen €1,400
47 €1,400
48 €1,400
49 €1,400
50 €1,400
51 Arto Loikkanen €1,400
52 €1,400
53 Tomi Arponen €1,400
54 €1,400
55 €1,400
56 €1,200
57 Ilari Sahamies €1,200
58 €1,200
59 €1,200
60 €1,200
61 €1,200
62 Toni Sarkama €1,200
63 €1,200
64 €1,200
65 Pyry Kekäläinen €1,200
66 Juho Suutari €1,200
67 Henri Tanskanen €1,200
68 €1,200
69 €1,200
70 €1,200
71 Ville Jantunen €1,200
72 €1,100
73 €1,100
74 €1,100
75 Markus Ylänne €1,100
76 €1,100
77 €1,100
78 Jani Tuovinen €1,100
79 €1,100
80 €1,100
81 €1,100
82 €1,100
83 €1,100
84 €1,100
85 €1,100
86 Per Halmrast €1,100
87 Glen Kolmer €1,100
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.