WSOPC Tallinn - Live Updates | MainEventTravel.com

0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0070 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-22' AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/30/118/updates' 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/30/118/updates', 1, '2024-11-22')

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

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

0.0293 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` = '98' AND `published` = 1

0.0298 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0272 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '118' AND `published` = 1

0.0293 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` = '119' AND `published` = 1

0.0066 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '118' 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_posts`.`published` = 1 AND `tour_stop_blog_day_id` = '118' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

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

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

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

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

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

Day 1b of Event #3: €350 No-Limit Hold'em attracted 183 entries to bring the total up to 383 entries for a €115,819 prize pool. A total of 23 players survived the day in the money for at least a €650 min-cash to bring the total survivors up to 49 players when taking into account the 26 survivors on Day 1a.

Northern Ireland's Joshua Stewart (pictured below) bagged the Day 1b chip lead with 346,000 placing him less than one big blind behind the overall chip leader in Stanislovas Norkus who managed to advance with 352,000 off his 20,000 start stack. Stewart had a heck of a day as he began Sunday at the final table of Event #2: €1,100 No-Limit Hold'em before bowing out in fourth place for €9,650.

The Day 2 seat draw will be posted soon in the Day 2 coverage with the official coverage starting when cards are in the air at noon on Monday when the winner of the third ring event will be crowned. In the meantime, check out all of the chip counts from Day 1b below:

Player	Chips
Joshua Stewart	346,000
Michele Tocci	316,000
Algirdas Saveikis	291,000
Viliu Zabarauskas	274,000
Dominik Ostrowski	260,000
Bjorn Lindberg	241,000
Jonas Ruginis	240,000
Vladislav Topilskiy	202,000
Evely Pihela	196,000
Celso Luiz De Almeida Rolim Junior	149,000
Jarmo Salonen	144,000
Marius Morel	140,000
Albert Gorelik	124,000
Lukas Kviecinskas	123,000
Albert Ostrovskij	118,000
Glen Gaines	85,000
Lukasz Fraczek	83,000
Rasmus Lundstrom	65,000
Eriks Krumins	63,000
Vilius Zamzickas	62,000
Keito Kaljulaid	57,000
Tapio Aaltonen	55,000
Veikka Keto-Tokoi	27,000