0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0078 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_555_Champ_Fin/1C/updates'
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_Fin/1C/updates', 1, '2024-11-22')

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.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'

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

0.0001 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.0002 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.0002 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.0032 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_Fin'

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

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

0.0312 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0080 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '234'
AND `published` = 1

0.0330 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0079 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '244'
AND `published` = 1

0.0005 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '100'
AND `name` = '1C'

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

0.0091 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_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '234'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

0.0098 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` = '9962'
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` = '9961'
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` = '9957'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0054 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` = '234'
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` = '10115'
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` = '9962'
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` = '9961'
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` = '9957'
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` = '244'
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 (Finnish) 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 400000
Entries 700 Remaining 1
Prize Pool (EUR) €329,000 First Prize (EUR) €65,360
Day 2 Day 1C Day 3
Live Updates Chip Counts Structure Gallery Payouts
1 New Update - Click to refresh
Live Updates - Day 1C
Suomalaiset erissä 1C ja 1D Posted Tuesday 27th February, 2024 at 10:30(UTC+2) by Juhani Tyriseva

Tervehdys! 

Blogi siis täyteen vauhtiin kohta, kun 555€  Championshipin päivä 2 käynnistyy. 

Suomalaiset jatkoon erästä 1C:

Juhana Konttinen 166K
Luka Sorainen 159K
Sebastian Wahl 116K 
Santtu Leinonen 110K
Anna-Mari Hursti 109K
Mikko Ylämäki 77K 
Jethro Rostedt 75K
Riku Hänninen 62K 
Tuomas Jalonen 59K
Sakari Setälä 58K
Kasper Mellanen 52K
Markus Pohjola 49K
Matias Knaapinen 47K
Aaron Kulomaa 45K 
Kevin Karenius 41K 
Juho Heiska 39K
Kristian Kostiander 35K 
Jani Tuovinen 34K 
Ari Varonen 34K 
Karri Uusi-Äijö 32K 
Tero Kilkanen 27K 
Arto Lehtonen 23K 
Johan Palokangas 23K 
Elias Vääräniemi 18K

Suomalaiset jatkoon erästä 1D: 

Henri Antikainen 106K
Rasmus Lundström 105K
Roope Tarmi 90K
Jani Vilmunen 78K 
Ville Lönngren 63K
Ngo Minh Thang 62K

Toni Sarkama 60K
Jukka Moisio 53K 
Joel Ylismäki 48K
Tomi Arponen 37K
Juha Kinnunen 33K 
Konsta Heikkilä 32K 
Jarkko Suokas 28K
Max Rotko 26K 
Roope Holma 21K

250 pelaajaa aloittaa päivän 2 avaamalla merkkipussin. Lisäksi kassan kautta tulee vielä jonkin verran lisää pelaajia.  Huikea päivä tulee, pysykää kanavalla!
Suomalaisten pinot erissä 1A ja 1B Posted Monday 26th February, 2024 at 15:09(UTC+2) by Juhani Tyriseva

Eilen sunnuntaina pelattiin siis 555€ Championshipin erät 1A ja 1B ja niissä nähtiin runsaasti suomalaisia. 

Kirjataanpa tähän jatkoon pelanneet meikäläiset: 

Suomalaiset jatkoon erässä 1A: 

Jimi Koponen 88K
Jyrki Lampinen 86K 
Mikael Haapaniemi 81K
Kalle Parkkinen 71K 
Juuso Kauppi 62K 
Osku Karttunen 49K
Matte Karjalainen 41K 
Johan Alen 33K 


Suomalaiset jatkoon  erässä 1B: 

Jussi Kivekäs 124K 
Akseli Paalanen 107K 
Touko Berndtson 106K 
Jose Koistinen 101K 
Elias Suhonen 96K 
Jonatan Fors 70K 
Joel Haapio 62K 
Jari Hurri 62K 
Markus Ylänne 59K 
Ville Turja 57K 
Aleksi Naski 55K 
Joonas Helin 54K 
Pyry Kekäläinen 36K 
Arto Loikkanen 25K 
Pekka Ikonen 22K
Petteri Miettinen 18K
Juho Suutari 10K 
Turnauksen suomenkielinen blogi lähtee tästä tiistaina klo 12.00!! Posted Monday 26th February, 2024 at 15:00(UTC+2) by Juhani Tyriseva

Tervehdys kaikki! 

Kings of Tallinn-turnausviikko on Pohjois-Euroopan suurin turnausviikko, ja tänä vuonna kisataan jo kymmenettä kertaa. Allekirjoittaneella on ollut ilo ja kunnia olla mukana kisaa seuraamassa jokaisella kisaviikolla. Tämäkään vuosi ei muodosta poikkeusta, vaikka vähän alusta jäikin nyt näkemättä. 

Turnauksen tärkeimmät tapahtumat nähdään ja seurataan tiistaista kisojen viimeiseen jakoon, joka siis jossain vaiheessa sunnuntaina. 

Pysykää kanavalla! 
14:50 (UTC+2)
Day 1C of Kings of Tallinn 2024 Started
Level: 4     Blinds: 200/400     Ante: 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.