0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0075 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/kings_of_tallinn_autumn_2024_555_champ/1B/chips'
ORDER BY `views` DESC

0.0063 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/kings_of_tallinn_autumn_2024_555_champ/1B/chips', 1, '2024-11-22')

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

0.0003 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.0004 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.0034 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` = 'kings_of_tallinn_autumn_2024_555_champ'

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

0.0288 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` = '447'
AND `published` = 1

0.0274 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0068 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '448'
AND `published` = 1

0.0281 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` = '449'
AND `published` = 1

0.0287 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` = '450'
AND `published` = 1

0.0283 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0064 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '452'
AND `published` = 1

0.0005 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '210'
AND `name` = '1B'

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

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

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

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

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

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

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

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

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

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

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

0.0005 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2596
English
Kings of Tallinn Autumn Edition 2024 Event #20 €555 NLH Kings of Tallinn Championship Live Reporting - Day 3
Kings of Tallinn Autumn Edition 2024 - Live Reporting Event #20 €555 NLH Kings of Tallinn Championship Event #27 €5,000 NLH Progressive Bounty Event #31: Kings of Tallinn €1,100 Main Event Event #52: €3,000 NLH Event #20 €555 NLH Kings of Tallinn Championship (Finnish) Event #31: Kings of Tallinn €1,100 Main Event (Finnish) Event #52: €3,000 NLH (Finnish)
Current Level 35 Current Day 3
Blinds 150,000/300,000 Ante 300000
Entries 583 Remaining 1
Prize Pool (EUR) €274,010 First Prize (EUR) €52,760
Day 1A Day 1B Day 1C Day 2 Day 3
Live Updates Chip Counts Structure Gallery Payouts
1 New Update - Click to refresh
Chip Counts - Day 1B
Place Player Chips Progress
1 Phil Gross 260,000 230,000
2 Tarmo Tammel 229,400 199,400
3 Timo Ruuska 172,000 142,000
4 Tanel Evert 157,000 127,000
5 Vasilij Barna 154,200 124,200
6 Irmantas Bzeskis 146,500 116,500
7 Taavi Pusa 141,600 111,600
8 Aleksandr Januskevic 137,000 107,000
9 Egidijus Digrys 134,000 104,000
10 David Bright 113,500 83,500
11 Audrius Laimelis 111,800 81,800
12 Borge Dypvik 107,700 77,700
13 Maikel Homin 106,400 76,400
14 Kristjan Maasalu 103,800 73,800
15 Andres Abakanov 103,000 73,000
16 Vidar Assersen 102,600 72,600
17 Mantas Stikelis 98,100 68,100
18 Algirdas Sukys 96,600 66,600
19 Pasi Trollhjarta 94,800 64,800
20 Pekka Lamberg 93,600 63,600
21 Koray Korkmaz 93,500 63,500
22 Viktor Snotko 91,100 61,100
23 Aurimas Stanevicius 87,100 57,100
24 Serhii Leonov 85,800 55,800
25 Michael Uguccioni 84,800 54,800
26 Menno De Velde 80,600 50,600
27 Joel Haapio 80,300 50,300
28 Yaniv Peretz 74,400 44,400
29 Oskari Piira 73,200 43,200
30 Hassan Sey 71,300 41,300
31 Aleksandr Scastnyj 71,200 41,200
32 Kaius Kiidli 71,100 41,100
33 Kazimieras Sileikis 69,300 39,300
34 Sami Starck 69,100 39,100
35 Andrejs Kovalovs 69,100 39,100
36 Rytis Pranarauskas 69,000 39,000
37 Olli Muukkonen 68,800 38,800
38 Benjamin Gros 68,200 38,200
39 Jose Koistinen 68,000 38,000
40 Sergejs Cugainovs 64,900 34,900
41 Magnus Pukk 62,300 32,300
42 Erkki Kaira 61,900 31,900
43 Otto Kiiskinen 60,000 30,000
44 Adrians Imsa 59,800 29,800
45 Mathias Siljander 57,300 27,300
46 Andrei Mjagkov 56,500 26,500
47 Sander Leigri 54,300 24,300
48 Stanislovas Vinicenka 51,400 21,400
49 Algirdas Saveikis 51,000 21,000
50 Igor Pihela Jr. 50,700 20,700
51 Hanna Heinlo 50,600 20,600
52 Enrique Martinez 50,000 20,000
53 Audrius Navickas 50,000 20,000
54 Harijs Erglis 49,600 19,600
55 Petteri Miettinen 49,500 19,500
56 Kristaps Sipols 49,300 19,300
57 Igor Pihela Sr. 48,600 18,600
58 Kasper Mellanen 48,400 18,400
59 Lars Hole 48,300 18,300
60 Tony Westby 47,300 17,300
61 Sebastian Wahl 47,200 17,200
62 Marius Bareisis 44,200 14,200
63 Niko Penttinen 43,500 13,500
64 Rene Peterkopf 43,200 13,200
65 Jon Gurrutxaga Alba 43,100 13,100
66 Yen Chi Chen 41,900 11,900
67 Aldas Gomas 41,700 11,700
68 Seppo Parkkinen 41,200 11,200
69 Alvils Bijons 41,000 11,000
70 Mitchell Hynam 40,900 10,900
71 Jari Aaltonen 40,500 10,500
72 Andre Magi 40,200 10,200
73 Lukasz Balbierz 39,900 9,900
74 Enea Subashi 39,200 9,200
75 Tapio Vihakas 39,000 9,000
76 Ulf Ulvrell 38,000 8,000
77 Iulian Chiriac 37,900 7,900
78 Markku Koplimaa 36,800 6,800
79 Niclas Mjelstad 36,400 6,400
80 Eduards Rakuss 34,900 4,900
81 Tapio Ilmari Aaltonen 34,800 4,800
82 Risto PŠrnat 34,400 4,400
83 Indre Martoviciute-Kasten 32,600 2,600
84 Hendrik Uibo 32,000 2,000
85 Jyri Tapio Merivirta 30,600 600
86 Bartosz Wojciech Wesolek 29,700 300
87 Joni Petri Lahti 29,200 800
88 Raimo Reimann 28,600 1,400
89 Povilas Jakutis 27,300 2,700
90 Sargon Esfendiyari 27,000 3,000
91 Ole Bull Nilsen 27,000 3,000
92 Viktors Caikins 24,600 5,400
93 Kevin Viktor Karenius 24,000 6,000
94 Julius Kasperi Kettunen 23,700 6,300
95 Jordi Conejos Baixas 23,500 6,500
96 Jani Alexanteri Tuovinen 23,200 6,800
97 Kaspars Butans 23,000 7,000
98 Pavel Plotnikov 22,800 7,200
99 Tanel Tammela 22,300 7,700
100 Robert Kallikorm 22,000 8,000
101 Sondre Stormyr 19,100 10,900
102 Klaudijus Bajoras 18,300 11,700
103 Ignotas Tamasauskas 18,200 11,800
104 Kari Petri Martikainen 17,700 12,300
105 Crispin E. G. Rovere 14,300 15,700
106 Josep Pastor De Ramon 10,900 19,100
107 Mantas Ungulaitis 9,600 20,400

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.