0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0704 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/32/101/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` = '32'

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

0.0424 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0599 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '101'
AND `published` = 1

0.0278 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0161 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '123'
AND `published` = 1

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

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

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

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

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

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

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

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

0.0068 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 #5: €660 No-Limit Hold'em Mystery Bounty Live Reporting - Day 2

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 19 Current Day 2

---

Blinds 5,000/10,000 Ante 10,000

Entries 164 Remaining 1

---

Prize Pool (EUR) €94,464 First Prize (EUR) €10,000

Chip Leaders Day 2

1

Ranno Sootla

4,920,000

Day 1 Day 2

Live Updates Chip Counts Structure Gallery Payouts

1 New Update - Click to refresh

Live Updates - Day 1

Vilius Zambauskas Leads Final 25 in Event #5: €660 NLH Mystery Bounty Posted Monday 18th September, 2023 at 21:12(UTC+0) by Jason Glatzer

The first of two opening days are in the books for Event #5: €660 No-Limit Hold'em Mystery Bounty. The event attracted 164 entries to create a €94,464 prize pool.

Just 15 percent of the field was scheduled to make it through into Day 2 near the money with just 25 players remaining and the top 20 players earning at least a min-cash of €650. This is just the minimum they will be playing for as tomorrow one player is slated to go home with a €10,000 top prize. 

The main reason players find this exciting is usually the mystery bounty prizes on tap for Day 2. One lucky player will win the top €10,000 mystery bounty tomorrow if the right envelope is pulled after an elimination.

Of course, with €10,000 to the winner along with the coveted WSOPC ring and the invitation to the $1 million Tournament of Champions freerolls held as a bracelet event at the 2024 WSOP in Las Vegas.

Lithuania's Vilius Zabrauskas is in the best position to collect mystery bounties as he will have the entire tournament covered from the start of Day 2 when the action kicks off at noon with 501,000. Nobody else is super close with Jarkko Suosas turning his 30,000 opening stack into 359,000.

Meanwhile, WSOP bracelet winner Ranno Sootla is in a good spot to add a ring to his collection despite spending most of his time these days playing cash games thanks to concluding the opening day with a third-place stack of 345,000.

Day 2 Seat Draw

Table	Seat	Player	Country	Chips	Big Blinds
1	1	Yusuke Tanaka	Japan	301,000	50
1	2	Stanislovas Norkus	Lithuania	212,000	35
1	3	Jarkko Suokas	Finland	359,000	60
1	4	Yanis Sahli	France	224,000	37
1	5	Vladimiras Meckovskis	Lithuania	114,000	19
1	6	Sebastian Wahl	Finland	284,000	47
1	7	Mark Metsla	Estonia	101,000	17
1	8	Bjorn Lindberg	Swden	99,000	17
1	9	Urmo Velvelt	Estonia	119,000	20
2	1	Roope Tarmi	Finland	159,000	27
2	2	Pekka Ikonen	Finland	156,000	26
2	4	Joel Holmberg	Finland	199,000	33
2	5	Andrius Bielskis	Lithuania	284,000	47
2	6	Ranno Sootla	Estonia	345,000	58
2	7	Martin Sedlak	Germany	124,000	21
2	8	Dominik Ostrowski	Poland	163,000	27
2	9	Kriss Riekstins	Latvia	49,000	8
3	1	Josep Pastor De Ramon	Spain	168,000	28
3	2	Roberts Rumba	Latvia	93,000	16
3	3	Jun Beum Chun	South Korea	323,000	54
3	5	Alius Riskevicius	Lithuania	32,000	5
3	6	Henri Vaisanen	Finland	171,000	29
3	7	Vilius Zabarauskas	Lithuania	501,000	84
3	8	Jesus Ucero	Spain	223,000	37
3	9	Marco Baglioni	Italy	60,000	10

Event #5 Payouts

Place	Prize
1	€10,000
2	€7,020
3	€5,100
4	€4,060
5	€3,054
6	€2,500
7	€2,040
8	€1,670
9	€1,390
10	€1,170
11	€960
12-14	€800
15-20	€650