0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0060 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/28/112/updates'
ORDER BY `views` DESC

0.0160 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/28/112/updates'

0.0003 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` = '28'

0.0005 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '28'

0.0262 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0043 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '97'
AND `published` = 1

0.0235 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0037 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '106'
AND `published` = 1

0.0762 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0040 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '111'
AND `published` = 1

0.0739 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` = '112'
AND `published` = 1

0.0236 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0046 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '113'
AND `published` = 1

0.1956 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0169 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '115'
AND `published` = 1

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

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

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

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

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

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

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

0.0649 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2143

    

Open Modal

Hi,

We'd like to send you push notifications so you never miss out on:

• Exclusive Offers
• Upcoming Events
• Exciting Promotions
• Poker Travel News

Don’t worry; we won’t bombard you with messages, and you can-opt out anytime by logging into your account and changing your settings.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

Translate

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Eesti
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Nederlands
• Ελληνικά
• Русский

WSOPC Tallinn Event #1: €555 No-Limit Hold'em Live Reporting - Day 3

WSOPC Tallinn - Live Reporting Event #1: €555 No-Limit Hold'em (Estonian) Event #3: €350 WSOPC Tallinn Ring Event (Estonian) Event #1: €555 No-Limit Hold'em Event #2: €1,100 No-Limit Hold'em Event #3: €350 No-Limit Hold'em Event #4: €555 Pot-Limit 2-7 Triple Draw Event #5: €660 No-Limit Hold'em Mystery Bounty Event #6: €1,500 WSOPC Tallinn Main Event Event #8: €1,100 PLO / PLO5 Event #9: €660 Pot-Limit Omaha Hi/Lo Event #11: €3,000 No-Limit Hold'em 6 Handed Event #12: €660 No-Limit Hold'em Progressive Bounty Event #6: €1,500 WSOPC Tallinn Main Event (Estonian)

---

Current Level 30 Current Day 3

---

Blinds 75,000/150,000 Ante 150,000

Entries 382 Remaining 1

---

Prize Pool (EUR) €183,360 First Prize (EUR) €34,435

Chip Leaders Day 3

1

Viacheslav Sultanov

11,500,000

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

Live Updates - Day 1D

Kalle Keski-Opas Bags Day 1d Chip Lead in Event #1: €555 No-Limit Hold'em Posted Friday 15th September, 2023 at 23:18(UTC+0) by Jason Glatzer

Finland's Kalle Keski-Opas bagged the chip lead in the fourth and final opening flight in WSOP Circuit Tallinn Event #1: €555 No-Limit Hold'em at Olympic Park Casino and the Hilton Tallinn Park and will begin Saturday's Day 2 with 187,500 in chips for 125 big blinds.

Vasco Segendorf (168,000), Dmitri Dudakov (152,000), Roland Luik (152,000), and Janne Nevalainen (131,000) all bagged top five stacks on Day 1d.

Event #1 has thus far attracted 320 entries for a €153,600 prize pool including 96 entries from Day 1d. The field and prize pool will continue to grow as unlimited re-entries are permitted during the first two blind levels of Day 2 until late registration has closed.

A total of 45 players survived Day 1d, bringing the total to 170 players to advance to Day 2 through the four opening flights. Check out all of the Day 1d chip counts below.

Player	Chips	Big Blinds
Kalle Keski-Opas	187,500	125
Vasco Segendorf	168,000	112
Dmitri Dudakov	152,000	101
Roland Luik	152,000	101
Janne Nevalainen	131,000	87
Aleksi Naski	113,000	75
Vladmir Iljunin	110,000	73
Edgars Beizaks	104,000	69
Vasileios Kokkinos	91,500	61
Agnius Sankaitis	90,500	60
Johan Grave	88,500	59
Andrey Koks	78,000	52
Dominykas Ruskys	75,500	50
Janne Havio	72,500	48
Jouni Knuutinen	68,500	46
Matiss Celmins	68,000	45
Yanis Mehdi Sahli	65,000	43
Ismail Borgi	60,500	40
Luca Beretta	60,000	40
Roope Holma	59,000	39
Kimmo Kurko	58,500	39
Alexander Nemchin	56,500	38
Marius Bacanskis	56,000	37
Johan Martinsen	55,500	37
Risto Parnat	54,500	36
Romas Bassus	53,000	35
Adria Comas I Roura	48,000	32
Jyri Erametsa	45,000	30
Artur Kulanurk	41,500	28
Alexander Klochkov	38,000	25
Jordi Baixas	33,500	22
Vilius Zamzickas	32,500	22
Inigo Naveiro	31,500	21
Martin Piik	31,500	21
Ville Mustonen	31,000	21
Matti Lasanen	30,500	20
Joona Ranta-Nilkku	29,500	20
Maksim Solodilov	29,000	19
Marko Hynynen	25,000	17
Jan-Mikael Kesanen	23,500	16
Joni Jokiniemi	22,000	15
Kaupo Tenno	20,500	14
Manoel Filho	17,500	12
Mateusz Mieczkowski	16,500	11
Arturs Daugis	8,000	5