0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0062 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-12-28'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/90/230/chips'
ORDER BY `views` DESC

0.0006 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/90/230/chips', 1, '2024-12-28')

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

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

0.0297 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` = '224'
AND `published` = 1

0.0291 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` = '230'
AND `published` = 1

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

0.0286 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0057 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '236'
AND `published` = 1

0.0294 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` = '237'
AND `published` = 1

0.0286 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` = '240'
AND `published` = 1

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

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

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

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

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

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

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

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

0.0108 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '231'
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` = '236'
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` = '237'
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` = '240'
ORDER BY `busted` ASC, `current_chips` DESC

0.0005 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2351
Translate
Kings of Tallinn 2024 Event #12: €555 Championship (English) 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) €58,835
Day 1A Day 1B Day 1C Day 1D 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 Mykhailo Mikhalov 180,600 150,600
2 Dmitrij Bogdanov 147,400 117,400
3 Serhii Leonov 145,700 115,700
4 Jussi Kivekas 124,100 94,100
5 Akseli Paalanen 107,400 77,400
6 Maciej Komorowski 106,900 76,900
7 Touko Berndtson 106,700 76,700
8 Jose Koistinen 101,000 71,000
9 Elias Suhonen 96,000 66,000
10 Dror Amiram 91,200 61,200
11 Natalia Manuyko 89,000 59,000
12 Peder Behr 88,500 58,500
13 Martins Priede 78,800 48,800
14 Emil Hovmark 74,200 44,200
15 Oleksii Lubnin 73,900 43,900
16 Jonatan Fors 70,700 40,700
17 Sven Omland 68,800 38,800
18 Serguei Palomera 65,100 35,100
19 Mirco De Martini 62,700 32,700
20 Svjatoslav Plohhotnitsenko 62,600 32,600
21 Joel Haapio 62,200 32,200
22 Jari Hurri 62,200 32,200
23 Rasmus Aavisto 62,100 32,100
24 Viacheslav Sultanov 59,900 29,900
25 Markus Ylanne 59,000 29,000
26 Federico Dos Santos 57,800 27,800
27 Ville-Oskari Turja 57,600 27,600
28 Kaspars Mallons 55,900 25,900
29 Aleksi Naski 55,500 25,500
30 Matteo Cappelletti 55,100 25,100
31 Joonas Helin 54,300 24,300
32 Christian Hoffmann 52,900 22,900
33 Joonas Kulli 52,800 22,800
34 Andres Allsalu 51,900 21,900
35 Jari Porkka 45,400 15,400
36 Thomas Larsen 42,900 12,900
37 Artur Kulanurk 42,700 12,700
38 Kris Tikka 42,500 12,500
39 Jevgenijs Kritinins 39,300 9,300
40 Andrii Momot 37,800 7,800
41 Laurynas Cerniauskas 37,300 7,300
42 Pyry Kekalainen 36,600 6,600
43 Algirdas Saveikis 35,600 5,600
44 Stanislav Smeljov 32,200 2,200
45 Marius Morel 25,200 4,800
46 Arto Loikkanen 25,200 4,800
47 Tomas Karvall 24,600 5,400
48 Pekka Ikonen 22,300 7,700
49 Petteri Miettinen 18,200 11,800
50 Oleksandr Shokur 16,400 13,600
51 Juho Suutari 10,300 19,700
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.