0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0071 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-23'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_1100_Main_Event/1c/chips'
ORDER BY `views` DESC

0.0010 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/2024_KOT_1100_Main_Event/1c/chips', 1, '2024-11-23')

0.0002 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.0001 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.0033 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_1100_Main_Event'

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

0.0279 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0047 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '241'
AND `published` = 1

0.0298 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0062 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '245'
AND `published` = 1

0.0290 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0059 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '250'
AND `published` = 1

0.0482 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0062 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '251'
AND `published` = 1

0.0278 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` = '256'
AND `published` = 1

0.0617 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0059 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '263'
AND `published` = 1

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '91'
AND `name` = '1c'

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

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

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

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

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

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

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

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

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

0.0007 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2351
English
Kings of Tallinn 2024 Event #29: €1,100 Main Event (English) 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 35 Current Day 4
Blinds 200,000/400,000 Ante 400000
Entries 914 Remaining 1
Prize Pool (EUR) €859,160 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
Chip Counts - Day 1c
Place Player Chips Progress
1 Irmantas Bzeskis 135,200 105,200
2 Henri Antikainen 123,500 93,500
3 Johan Karlsson 102,700 72,700
4 Kestutis Jungevicius 100,200 70,200
5 Miska Vihervuori 93,500 63,500
6 Mihkel Vohla 82,700 52,700
7 Jari Lahtinen 80,200 50,200
8 Elias Jalovaara 76,500 46,500
9 Mattias Hansen 75,600 45,600
10 Niklas Vakkuri 72,400 42,400
11 Juho Heiska 72,300 42,300
12 George Sandford 67,700 37,700
13 Rickard Rohani 67,400 37,400
14 Johan Palokangas 63,000 33,000
15 Mihkel Merekula 61,500 31,500
16 Jukka Moisio 60,200 30,200
17 Kasper Mellanen 58,500 28,500
18 Madis Muur 58,000 28,000
19 Yana Gorskaya 57,500 27,500
20 Marks Sergins 57,500 27,500
21 Juuso Oksanen 56,300 26,300
22 Juan Deunas 56,300 26,300
23 Dmitrij Bogdanov 56,200 26,200
24 Alf Onnestam 54,800 24,800
25 Trond Aanestad 54,100 24,100
26 Tadas Pranckevicius 52,100 22,100
27 Martynas Kaulakys 51,700 21,700
28 Audrius Navickas 50,800 20,800
29 Thomas Haverstad 50,700 20,700
30 Doroslav Rasiukevic 49,800 19,800
31 Anna-Mari Hursti 48,100 18,100
32 Anne Koskinen 48,000 18,000
33 Joonas Helin 47,700 17,700
34 Emanuele Mari 47,600 17,600
35 Sander Lithun 44,600 14,600
36 David Ozmen 42,400 12,400
37 Joshua Stewart 41,500 11,500
38 Osku Karttunen 40,500 10,500
39 Massimo Casabona 40,400 10,400
40 Pasi Sormunen 38,300 8,300
41 Ulf Bredenberg 36,500 6,500
42 Jazouli Idrissi 35,100 5,100
43 Heikki Kinnunen 34,300 4,300
44 Lars Andersson 33,900 3,900
45 Hai Hoang 33,400 3,400
46 Eetu Porkka 32,800 2,800
47 Lars Jonsson 32,100 2,100
48 Oscar Peleg 31,500 1,500
49 Justas Vaiciulionis 31,100 1,100
50 Dominykas Skrinska 28,700 1,300
51 Antti Makela 28,600 1,400
52 Even Rislov 28,300 1,700
53 Emil Heikkinen 27,600 2,400
54 Viktor Eriksson 27,600 2,400
55 Anne Bezdek 27,300 2,700
56 Eleftherios Sinnos 27,300 2,700
57 Nikolaos Ktenas 23,500 6,500
58 Kiur Koster 21,000 9,000
59 Sander Leigri 19,300 10,700
60 Joachim Gjerstad 18,100 11,900
61 Marten Rimmel 18,100 11,900
62 Andrei Harlanov-Voogla 15,800 14,200
63 Andrea Benelli 15,800 14,200
64 Virgo Laansoo 15,000 15,000
65 Kim Lindstrom 14,600 15,400
66 Jesperi Jarvinen 12,800 17,200
67 Kent Lindback 11,500 18,500
68 Max Rotko 10,400 19,600
69 Gintaras Naglius 10,300 19,700

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.