WSOP Circuit Events - WSOPC Tallinn - Live Coverage

0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0077 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-22' AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event1/1C/updates' ORDER BY `views` DESC

0.0007 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event1/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.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.0035 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.0006 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` = 'wsopctallinn_2023_event1'

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

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

0.0275 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` = '106' AND `published` = 1

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

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

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

0.0269 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` = '115' AND `published` = 1

0.0003 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '28' AND `name` = '1C'

0.0060 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.0059 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.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` = '4553' 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` = '111' ORDER BY `busted` ASC, `current_chips` DESC

0.0052 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.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` = '4553' 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` = '115' ORDER BY `busted` ASC, `current_chips` DESC

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

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

Browse

Useful Links

Browse

Useful Links

Subscribe to our newsletter