0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0066 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2025-08-02'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_555_Champ_Est/2A/payouts'
ORDER BY `views` DESC

0.0008 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/2024_KOT_555_Champ_Est/2A/payouts', 1, '2025-08-02')

0.0003 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'

0.0003 SECONDS: 
SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0002 SECONDS: 
SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0

0.0004 SECONDS: 
SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

0.0001 SECONDS: 
SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`

0.0003 SECONDS: 
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'

0.0037 SECONDS: 
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
 LIMIT 30

0.0005 SECONDS: 
SELECT tour_stop_blogs.*, 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.logo as tour_stop_logo, 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 `friendly_url` = '2024_KOT_555_Champ_Est'

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

0.0276 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` = '226'
AND `published` = 1

0.0278 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0054 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '227'
AND `published` = 1

0.0280 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0052 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '232'
AND `published` = 1

0.0277 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` = '235'
AND `published` = 1

0.0280 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` = '238'
AND `published` = 1

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '95'
AND `name` = '2A'

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

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

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2351
English
Kings of Tallinn 2024 Event #12: €555 Championship (Estonian) Live Reporting - Day 2
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 21 Current Day 2
Blinds 10,000/15,000 Ante 15000
Entries 700 Remaining 1
Prize Pool (EUR) €329,000 First Prize (EUR) €0
Day 1A Day 1B Day 1C Day 1D Day 2
Live Updates Chip Counts Structure Gallery Payouts
1 New Update - Click to refresh
Payouts
Place Player Prize (EUR)
1 Mikko Tapani Ylämäki €57,860
2 Andrius Bielskis €49,000
3 Joonas Helin €27,900
4 Itai Oscar Peleg €20,100
5 Baixas Jord Conejos €15,200
6 Aleksandrs Krumins €11,250
7 Touko Teivonpoika Berndtson €8,700
8 Matte B.P Karjalainen €7,200
9 Knut Trulsen €5,890
10 Konsta Ilmari Heikkilä €4,700
11 Svetozar Marinov €4,700
12 Jan-Mikael Juhani Kesänen €3,600
13 Adrians Imsa €3,600
14 Christian Rysgaard €2,850
15 Viktorija Ignataviciene €2,850
16 Moya Javier Guinot €2,150
17 Thor William Holm Morstol €2,150
18 Matteo Cappelletti €2,150
19 Serhii Leonov €2,150
20 Sultans Ertinhajevs €2,150
21 Peder Behr €2,150
22 Paulius Jucys €2,150
23 Presiyan Georgiev Tsvetanov €2,150
24 Joel Edvin Ylismäki €1,800
25 Mykhailo Mikhalov €1,800
26 Dmitrijs Arsuns €1,800
27 Vytautas Laurinaitis €1,800
28 Edgaras Kausinis €1,800
29 Mats Fredrik Forss €1,800
30 Kevin Viktor Karenius €1,800
31 Jani Petteri Vilmunen €1,800
32 Jonatan Fors €1,600
33 Audrius Skucas €1,600
34 Roope O. O. Tarmi €1,600
35 Dmitri Zatsik €1,600
36 Juuso Johannes Oksanen €1,600
37 Rodriguez Angel Alsonso €1,600
38 Luka Arno Oskari Sorainen €1,600
39 Mathias Olof Christensen €1,600
40 Tanel Evert €1,400
41 Akseli Timonpoika Paalanen €1,400
42 Ville-Oskari Sebastian Turja €1,400
43 Niklas Gjersvold €1,400
44 Dangiras Kuzulis €1,400
45 Aleksandr Kuperman €1,400
46 Kasper J. O. Mellanen €1,400
47 Gundars Zelcs €1,400
48 Hans Göran Erlandsson €1,400
49 Erik Põlluveer €1,400
50 Aleksei Smirnov €1,400
51 Arto Ilmari Loikkanen €1,400
52 Espinosa Luezas €1,400
53 Tomi Arponen €1,400
54 Eldars Sadih-Zade €1,400
55 Bengt-Anders O.Y. Johnsson €1,400
56 Viacheslav Sultanov €1,200
57 Ilari Sahamies €1,200
58 Magnus Pukk €1,200
59 Viktor Chaikin €1,200
60 Meelis Meliste €1,200
61 Mattias Erik Hansen €1,200
62 Toni Matias Sarkama €1,200
63 Daniel Graham Smith €1,200
64 Kevin Didvig €1,200
65 Pyry N. H. Kekäläinen €1,200
66 Juho Suutari €1,200
67 Henri Elias Tanskanen €1,200
68 Modestas Kryzanauskas €1,200
69 Dmitrij Bogdanov €1,200
70 Igor Pihela vanm €1,200
71 Ville Olavi Jantunen €1,200
72 Rik Van Etten €1,100
73 Thomas Haverstad €1,100
74 Dominik Ostrowski €1,100
75 Markus Tapio Ylänne €1,100
76 Kaarel Võhandu €1,100
77 Natalja Manuyko €1,100
78 Jani Alexanteri Tuovinen €1,100
79 Tobias Napel €1,100
80 Christopher Ekvall €1,100
81 Akram Van Marcus €1,100
82 Rain Kandla €1,100
83 Dos Santos Alves €1,100
84 Nils Butevics €1,100
85 Tanel Merida €1,100
86 Per Overaasen Halmrast €1,100
87 Glen Kolmer €1,100

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333
Browse
News Tours Festivals Venues Offers & Packagess
Useful Links
My Account Terms & Conditions Privacy Policy About Us Enquiry Form
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.