0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0096 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/28/111/updates', 1, '2024-07-27')

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.0009 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '28'

0.0233 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` = '97'
AND `published` = 1

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

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

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

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

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

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

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

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

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

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

0.0051 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.0003 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 1C

Charles-Eric Benoit Bags Day 1c Chip Lead Posted Friday 15th September, 2023 at 21:50(UTC+0) by Jason Glatzer

Day 1c more than doubled the existing field in WSOP Circuit Tallinn Event #1: €555 No-Limit Hold'em with 123 entries bringing the total up to 224 entries with still one more flight to go with Day 1d kicking off on Friday at 7 p.m.

A total of 76 players survived, bringing the total up to exactly 150 players already advancing to Day 2. Canada's Charles-Eric Benoit (pictured above) bagged the Day 2 chip lead with 143,000 followed by Georgios Tsouloftas (112,500), James Noonan (109,000), Igor Pihela Jr. (109,000), and Sami-Sander Kivi (108,500).

This entire group will begin Day 2 behind Day 1a chip leader Raivo Pinsel (219,000) and Day 1b chip leader Max Avela (184,000).

Our coverage will officially begin when Day 2 kicks off at noon on Saturday with blinds beginning at 1,000/1,500 along with a 1,500 big blind ante and increase every 30 minutes. The plan for Day 2 is to play down to a final table of nine hopefuls who will then battle it out on a live-streamed final table until the first ring winner is crowned on Sunday.

Player	Chips	Big Blinds
Charles-Eric Benoit	143,000	95
Georgios Tsouloftas	112,500	75
James Noonan	109,000	73
Igor Pihela Jr.	109,000	73
Sami-Sander Kivi	108,500	72
Masse Mirza	105,000	70
Arko Apenparg	100,500	67
Albert Ostrovskij	96,500	64
Mario Jurgens	90,500	60
Viktor Blinov	89,500	60
Urmo Velvelt	89,500	60
Kazimieras Ramaska	86,500	58
Morten Bremseth	83,500	56
Yusuke Kakiuchi	80,500	54
Janek Tammsaar	78,500	52
Evgeny Kerimov	73,000	49
Seppo Lehtonen	71,500	48
Kjetil Hanstvedt	64,500	43
Boris Smolianskii	64,500	43
Samuel Saariaho	64,000	43
Stig Mattsson	62,000	41
Martin Sediak	61,000	41
Viacheslav Sultanov	60,500	40
Rimantas Boguzas	59,000	39
Rene Peterkopf	56,500	38
Jorge Paredas Bravo	56,000	37
Tadas Karosas	55,500	37
Vladimiras Meckovskis	53,000	35
Tanel Evert	52,000	35
Martin Venno	51,000	34
Todd Jatras	48,500	32
Zydrunas Karcemarskas	43,000	29
Janar Kokk	40,500	27
Maksim Petrov	40,000	27
Maikel Homin	38,500	26
Stanislovas Norkus	37,500	25
Yusuke Tanaka	36,500	24
Karlis Kreslins	36,000	24
Joni Rantamaki	36,000	24
Daniel Kunman	35,500	24
Markku Vihavainen	35,500	24
Ken Okada	35,000	23
Steponas Vencus	35,000	23
Marko Vest	35,000	23
Tanel Koht	34,000	23
Martin Oks	33,000	22
Feras Abid	32,000	21
Nils Gard	31,500	21
Timo Perttunen	31,000	21
Aleksei Smirnov	29,000	19
Siim Suviste	28,500	19
Edgars Maurmanis	28,000	19
Ramunas Mika	27,000	18
Tarmo Tammel	27,000	18
Linas Jautakis	26,500	18
Marco Kolle	26,000	17
Andrei Mjagkov	26,000	17
Jonas Ruginis	25,500	17
Heikki Hutala	25,000	17
Anna-Mari Hursti	25,000	17
Hanno Kerem	25,000	17
Ermo Kosk	25,000	17
Kaur Ajamaa	24,000	16
Samuli Hietala	24,000	16
Antonios Onofriou	24,000	16
Jouni Kahosalo	23,500	16
David Lopez de Miguel	23,000	15
Kostiantyn Svystunov	23,000	15
Oskar Ojaveer	22,500	15
Michele Tocci	21,500	14
Saulius Tumosa	21,500	14
Joel Holmberg	20,500	14
Vytautas Kacerauskas	19,500	13
Domene Larios	19,500	13
Ucero Martinez	18,000	12
Vygerdas Jonikas	12,500	8