0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0007 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event5/1/updates', 1, '2024-11-18')

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'

0.0001 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.0001 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.0001 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.0002 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.0002 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.0039 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` = '2024_wsop_tallinn_event5'

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

0.0282 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` = '328'
AND `published` = 1

0.0277 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` = '336'
AND `published` = 1

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '140'
AND `name` = '1'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0058 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` = '328'
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` = '14507'
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` = '14480'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0005 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2553
English
Olympic Park Casino Event #5: €250 NLH Queens Live Reporting - Day 2
Olympic Park Casino - Live Reporting Event #1: €250 No-Limit Hold'em (Estonian) Event #1: €250 No-Limit Hold'em Event #3: €555 No-Limit Hold'em Event #4: €350 PLO4&5 Progressive Bounty Event #5: €250 NLH Queens (Estonian) Event #5: €250 NLH Queens Event #6: €1M GTD €1,500 Main Event (Estonian) Event #6: €1M GTD €1,500 NLH Main Event Event #7: €1,100 PLO4&5 Event #8: €1,100 NLH Mystery Bounty Event #9: €3,000 No-Limit Hold'em Six-Max (Estonian) Event #9: €3,000 No-Limit Hold'em Six-Max Event #3: €555 No-Limit Hold'em (Finnish) Event #6: €1M GTD €1,500 NLH Main Event (Finnish) Event #7: €1,100 PLO4&5 (Finnish) Event #9: €3,000 No-Limit Hold'em Six-Max (Finnish)
Current Level 27 Current Day 2
Blinds 40,000/80,000 Ante 80000
Entries 90 Remaining 1
Prize Pool (EUR) €19,008 First Prize (EUR) €5,570
Day 1 Day 2
Live Updates Chip Counts Structure Gallery Payouts
1 New Update - Click to refresh
Live Updates - Day 1
Offers & Promos Posted Tuesday 23rd July, 2024 at 14:39(UTC+2) by Matthew Summers

Main Event Travel is dedicated to providing the number one Poker Travel booking platform for players heading to tournaments around the world.

Join our Facebook Group, your gateway to offers and promotions created specifically for Poker Travellers looking for convenience, value, info, and expert customer service.

Join today ?? https://www.facebook.com/groups/maineventtraveloffersandpromotions/
Westerlund Massive Lead Going Into The Final Table Posted Tuesday 23rd July, 2024 at 04:07(UTC+2) by Lina Olofsson

As the first day of the WSOP Circuit Queens Event here in Tallinn has come to an end and it's time to wrap everything up it's safe to say that it was beyond expectations. Both the turn up with it's 90 entries in the field but also when it's time for the final table here tomorrow. 

Eight months ago Olybet tried something new here when they threw the first ever women's only poker festival under the name Queens of Tallinn. A tournament festival which ended up with Lithuanian Marta Porter winning the first ever main event during a women's tournament series. And surely Tallinn and Hilton Park brings something special to Mrs Porter as she's now yet again amongst the final nine players as we've reached the final nine. Porter is second in chips when the play resumes at 4 pm tomorrow afternoon. 

Ahead of Porter we have the only Swede in the field and someone who probably also considers Tallinn to be "home soil" as she's now considered to be one of this venues regulars. Jenny Westerlund has been on the poker scene longer than most players in the field and showed a combination of skills and luck along today's game. That's exactly what poker is about. Good players make sure to find their spots to collect and for Westerlund this lead to a massive lead going into tomorrow. She has more than double the amount of her closest competitor Porter. 

When the play resumes tomorrow we continue on the 17th level with blinds 4,000, 8,000 (BBA 8,000) and the chip count will look as follow: 

  1. Jenny Westerlund - Sweden - 761,000
  2. Marta Porter - Lithuania - 321,000
  3. Kristiina Sultangarejev-Tuder - Estonia - 303,000
  4. Cristina Jugastru - Romania - 281,000
  5. Linda Madleena Lahdenpaa - Finland - 266,000
  6. Linda Nguyen - Norway - 129,000
  7. Anu Kristiina Lilja - Finland - 65,000
  8. Ruth Guper - Israel - 58,000
  9. Mirjam Jalak - Estonia - 42,000
Aiste Jakutiene Bubble The Final Table Posted Tuesday 23rd July, 2024 at 03:03(UTC+2) by Lina Olofsson

After some action on both the two remaining tables, it would all come to an end at the 17th level of day one here in the WSOPC Queens event. With 18 minutes left on the clock, Lithuanian Aiste Jakutiene was all-in against home player Kristiina Sultangarejev-Tuder. 

Jakutiene looked in good shape with her Ace-Ten versus her opponent who had a slightly worse kicker with Ace-Eight. But the gods of poker were reckless when the board not only came with an ace but also an eight giving her opponent two pairs and sending the Lithuanian to the rail in tenth place as the remaining nine bagged their chips as we called it a night.   

Stay tuned for a chip count of the remaining nine players. While you wait, have a look in the gallery!  
Final Table Bubble Posted Tuesday 23rd July, 2024 at 02:22(UTC+2) by Lina Olofsson

We lost our first player in the money as Riitta Liisa Sahala was eliminated from the tournament. 

The last ten players are now competing, five on each table, to make it to the final table of nine before we pack our bags, call it a night, and resume the play tomorrow for the live stream. 
Blochlinger And Martoviciute Bubble Posted Tuesday 23rd July, 2024 at 02:03(UTC+2) by Lina Olofsson

Poker Globetrotter Maureen Blochlinger just came by the bloggers HQ telling us she busted on the bubble as she finished the €250 Queens Event on 13th place. The very same minute Lithuanias Indre Martoviciute busted on the other table and the both bubbled leaving the last eleven players in the money in this event guaranteed €504 for their efforts. 
Player Chips Progress
Indre Martoviciute 0 0
Maureen Blochlinger 0 0
Hand By Hand Posted Tuesday 23rd July, 2024 at 01:24(UTC+2) by Lina Olofsson

We are down to the last 13 players. 11 of these ladies will receive at least €504 of the total prize pool of €19,008 up for grabs. But first one more player will walk out of this €250 Queens tournament before we reach the money. The two tables are now playing the tournament hand-for-hand until we are there.
Miss Westerlund Takes The Throne Posted Tuesday 23rd July, 2024 at 01:04(UTC+2) by Lina Olofsson

In the Game of Thrones here in WSOPC in Tallinn, we are down to the last two tables. The €250 Queens event has reached its first of three milestones here tonight. We are down to the first re-draw of today with 16 players left. Next up is to reach the money with the eleven places getting paid. The very last step is the final nine. 

As we were down to the last 17 Jenny Westerlund, the only Swede in the field, sat with a comfortable stack. Jenny who's been on the poker scene for many, many years is to be considered a regular here in Tallinn and today surely the gods of poker seem to be with her. With a huge stack that took both her and the floor to move to balance the tables she only just sat down at the table when looking down on a pair of kings. After her raise, Itziar Lopez pushed all-in with pocket tens and Miss Westerlund had no problem calling and the blank board sent her opponent to the rail as Westerlund continued building her massive stack. 

The players are now on a break as we are making a re-draw and counting some chips. 
Three Tables Posted Tuesday 23rd July, 2024 at 00:02(UTC+2) by Lina Olofsson

With a few minutes left on the clock of the 12th level at the Hilton Park and Olympic Casino, we are down to the last three tables in the €250 Queens Event. 24 players remain out of the 90 entries that were made in total in this prestigious event. 

We are playing down to the final nine players before we can call it a night and wrap everything up until it continues tomorrow afternoon with the televised feature table.
€5,570 Up For Grabs Posted Monday 22nd July, 2024 at 23:58(UTC+2) by Lina Olofsson

The registration has closed and we have the final numbers in the €250 No Limit Hold'em Queen Event. 90 entries in total give a prize pool of €19,008 to play for, with a cherry on top awarding the eventual winner of this event €5,570, next to the golden WSOP Circuit Ring. 
76 And Counting Posted Monday 22nd July, 2024 at 21:08(UTC+2) by Lina Olofsson

We've reached level seven in the €250 Queens event and the field is now up to 76 players. About 20 of them have busted but quite a few have made a re-entry and fired another bullet. The registration continues to be wide open until we reach the end of level nine when we have our official numbers. 
Many Familiar Faces Posted Monday 22nd July, 2024 at 18:51(UTC+2) by Lina Olofsson

There are a lot of familiar faces in the €250 Queens event as the players went on the first break of the day here at Hilton Park in Tallinn. This is a two-day event where the final table will be the first event you can watch on our Livestream tomorrow afternoon. 

Among the players who entered the field and the hunt for that luxurious golden WSOP Circuit ring, we have the always so charming and well-renowned Sara Chafak from Finland, Irish superstar Karen Muir, Estonian charm Giedre Valgemae, Suiss globetrotter Maureen Blochlinger and Latvias finest Indre Martoviciute. 
Player Chips Progress
Indre Martoviciute 25,000 0
Maureen Blochlinger 25,000 0
Giedre Valgemae 25,000 0
Karen Muir 25,000 0
Sara Chafak 25,000 0
Bezdek Fires Another Bullet Posted Monday 22nd July, 2024 at 18:26(UTC+2) by Lina Olofsson

We are in the third level of the €250 Ladies Only Event. So far more than 50 queens have entered the tournament. One of these queens has even done it twice. Ae Bezdek couldn't make her first bullet work and after losing all of her chips she decided that second times a charm and bought in again. 
Player Chips Progress
Anne Bezdek 25,000 0
Cards in the Air Posted Monday 22nd July, 2024 at 17:09(UTC+2) by Jason Glatzer

Level 1: 100/100 (100)
Entries: 24/24

Cards are in the air to start the two-day €250 Queens with a couple of dozen ladies in the field. Daiva Byrne, Anne Bezdek, Christel Haller, Ave Lepik, Marita Magi, Linda Nguyen, Ausra Razmaite, and Jenny Westerlund are among the players from the start.

Esteemed reporter Lina Olofsson will primarily cover the live reporting for this event. Best of luck to all players in the €250 NLH Queens Ladies Only ring event.
Player Chips Progress
Jenny Westerlund 25,000 0
Ausra Razmaite 25,000 0
Linda Nguyen 25,000 0
Marita Magi 25,000 0
Ave Lepik 25,000 0
Christel Haller 25,000 0
Anne Bezdek 25,000 0
Daiva Byrne 25,000 0
17:00 (UTC+2)
Day 1 of Olympic Park Casino Started
Level: 1     Blinds: 100/100     Ante: 100
History to Be Made on Sunday in the Event #5: €250 Queens Posted Monday 22nd July, 2024 at 14:14(UTC+2) by Jason Glatzer

Get ready for some fun and excitement. For the first time ever, Olympic Park Casino and OlyBet are hosting a ring event just for the ladies. The two-day €250 NLH Queens Ladies Only will start its opening day at 5 p.m.

FLIP's Daiva Byrne (pictured below) is making a comeback, joined by a host of other esteemed ladies, including Globetrotting Poker's Maureen Bloechlinger, who made it to the final table on Sunday in the €250 No-Limit Hold'em ring event.

The event follows a tradition of inclusiveness and diversity that OlyBet has been championing. Every major festival includes a Queens event and festivities, fostering a sense of community and belonging. Last year, OlyBet hosted a Ladies-Only festival in the Queens on Tallinn for the first of its kind in Europe, which is planned to return at the end of this year as well.

Several freerolls were hosted for this event, including one at 2 p.m. today, which guaranteed five seats for today's big show.

The event will provide plenty of action, with players starting off with 25,000 in chips and blinds, which increase every 30 minutes. Players can re-enter until their hearts are content for the first nine blind levels, and the first day will conclude when an official final table is reached.

The action will resume for the final table on Tuesday at 4 p.m. where poker fans can enjoy the show via the first live stream of the 2024 WSOP Circuit Tallinn at OlyBet.tv and other channels.

Big money for the ladies will be on the line, but this is not all. The winner will also be awarded a WSOP Circuit gold ring and an invite for a free chance at more WSOP hardware in the form of a bracelet where they will compete against other ring and bracelet winners next summer in a $1 million guaranteed Tournament of Champions freeroll.

Best of luck to all the Ladies, and stay tuned. We will report on this event from the beginning until a winner is crowned on Tuesday.

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333
Browse
News Tours Festivals Venues Offers & Packagess
Useful Links
My Account Terms & Conditions Privacy Policy About Us Enquiry Form
Your search results are valid for . More Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.