0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0076 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/101/243/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/101/243/payouts', 1, '2024-11-22')

0.0003 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` = '101'

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '101'

0.0271 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` = '243'
AND `published` = 1

0.0275 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` = '246'
AND `published` = 1

0.0272 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` = '248'
AND `published` = 1

0.0274 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` = '253'
AND `published` = 1

0.0272 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0053 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '259'
AND `published` = 1

0.0273 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` = '265'
AND `published` = 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2351
Translate
Kings of Tallinn 2024 Event #29: €1,100 Main Event (Finnish) Live Reporting - Day 4
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 34 Current Day 4
Blinds 150,000/300,000 Ante 300,000
Entries 853 Remaining 1
Prize Pool (EUR) €859,270 First Prize (EUR) €120,910
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 Edgaras Kausinis €120,910
2 Mantas Tamalevicius €105,000
3 Aleksi Naski €105,000
4 Benjamin Gros €54,800
5 Even Rislov €39,600
6 Greger Aktell €30,350
7 Wissam Polus €23,100
8 Paul Newey €17,800
9 Mindaugas Jonaitis €13,500
10 Herli Olop €10,500
11 Frederik Brink €10,500
12 Kaido Mikk €8,300
13 Luca Beretta €8,300
14 Dominik Ostrowski €7,100
15 Rolandas Aglinskas €7,100
16 Nikita Zarovs €6,150
17 Tarmo Tammel €6,150
18 Martynas Mockevicius €5,400
19 Sven Otto Omland €5,400
20 Aleksei Smirnov €5,400
21 Benny Hagberg €4,800
22 Audrius Skucas €4,800
23 Josep De Ramon Pastor €4,800
24 Kasper Mellanen €4,250
25 Jani Vilmunen €4,250
26 Roope Tarmi €4,250
27 Bengt-Anders Johnsson €4,250
28 Andrei Silencov €3,750
29 Ignacio Garrido €3,750
30 Sebastian Wahl €3,750
31 Jimi Koponen €3,750
32 Albert Gil €3,350
33 Trond Aanestad €3,350
34 Andrius Bielskis €3,350
35 Ranel Kasi €3,350
36 Svein Mathiassen €3,350
37 Jyrki Lampinen €3,350
38 Morten Norland €3,350
39 Jonatan Fors €3,350
40 Osku Karttunen €2,950
41 Paulius Jucys €2,950
42 Klavs Garselis €2,950
43 Antti Perttula €2,950
44 Tomi Rissanen €2,950
45 Sauli Haapaniemi €2,950
46 Kris Tikka €2,950
47 Tarjei Forus €2,950
48 Enea Subashi €2,950
49 Maximilian Sanders €2,950
50 Alexander Sokolovsky €2,950
51 Miska Vihervuori €2,950
52 Thomas Larsen €2,950
53 Gediminas Dirmantas €2,950
54 Peer Zahl €2,950
55 Ilari Sahamies €2,950
56 Sandis Blums €2,600
57 Patrikas Aglinskas €2,600
58 Steven Tool €2,600
59 Henning Andre €2,600
60 Niclas Mjelstad €2,600
61 Mattias Hansen €2,600
62 Viktor Eriksson €2,600
63 Peter Jaksland €2,600
64 Thomas Haverstad €2,600
65 Mikko Ylamaki €2,600
66 Johan Karlsson €2,600
67 Henri Kasper €2,600
68 Kaius Kiidli €2,600
69 Kenneth Svendsen €2,600
70 Adrians Imsa €2,600
71 Kaur-Silver Koha €2,600
72 Mihkel Vitsur €2,350
73 Joonas Helin €2,350
74 Paul Koppe €2,350
75 Ignas Vaitulionis €2,350
76 Fritz Nygren €2,350
77 Mark Metsla €2,350
78 Marius Morel €2,350
79 Gatis Maisins €2,350
80 Stein Naerland €2,350
81 Jon Martinez €2,350
82 Vytautas Laurinaitis €2,350
83 Vasilijus Piskunovas €2,350
84 Per Engstrom €2,350
85 Mykolas Guiga €2,350
86 Jani Tuovinen €2,350
87 Kalle Parkkinen €2,350
88 Petteri Miettinen €2,350
89 Mairo Tori €2,350
90 Tomi Arponen €2,350
91 Jari Saviaho €2,350
92 Aurelijus Sipavicius €2,350
93 Sascha Manns €2,350
94 Shachar Haran €2,350
95 Jari Hurri €2,350
96 Lauri Laast €2,100
97 Jesper Hansen €2,100
98 Rytis Pranarauskas €2,100
99 Karl Linder €2,100
100 Anne Bezdek €2,100
101 Adria Comas I Roura €2,100
102 Jari Mahonen €2,100
103 Jari-Pekka Juhola €2,100
104 Christian Rysgaard €2,100
105 Mindaugas Kriauciunas €2,100
106 Rolf Jauring €2,100
107 Olegs Petrovskis €2,100
108 Ignas Navickas €2,100
109 Silver Simulask €2,100
110 Oscar Peleg €2,100
111 Matias Knaapinen €2,100
112 Vidar Furu Oie €2,100
113 Javier Moya €2,100
114 Ignas Jasinevicius €2,100
115 Arto Lehtonen €2,100
116 Richard Koppel €2,100
117 Matias Kesanen €2,100
118 Marcus Van Akram €2,100
119 Sampo Ryynanen €1,050
120 Henri Wagner €1,050
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.