0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

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

0.0003 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.0003 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'

0.0002 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.0004 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.0003 SECONDS: 
SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0

0.0006 SECONDS: 
SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC

0.0004 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.0004 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 `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`

0.0006 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.0004 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.0119 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.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '140'

0.1052 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.0808 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0108 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '336'
AND `published` = 1

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

0.0054 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.0080 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.0557 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.0054 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.0054 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.0053 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.0056 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.0054 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.0054 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.0664 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.0069 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.0164 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.0056 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.0161 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.0054 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.0493 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.0054 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.0056 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.0045 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.0174 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.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` = '14480'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0175 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.0104 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.0517 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.0163 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.0189 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.0692 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.0169 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.0111 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.0075 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.0058 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.0055 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2553

    

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

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

• Home
• My Account
• Calendar
• Live Reporting
  •   Live Reporting
  •   Live Streams
• News & Blogs
• Offers & Packages
• Events
  • VIEW ALL >
  • 888poker LIVE(1)
  • 888poker UK Poker League(3)
  • APAT(5)
  • APPT(2)
  • Aria Resort & Casino(1)
  • Asian Poker Tour(1)
  • Aspers Casino Westfield Stratford City(4)
  • Battle Of Malta(1)
  • Borgata Poker(2)
  • Bratislava Poker Festival(0)
  • British Poker Series(4)
  • BSOP(2)
  • Circuito Nacional De Poker(0)
  • Costa Rica Poker Festival(1)
  • Dublin Poker Festival(0)
  • Dusk Till Dawn(6)
  • EAPT(3)
  • EPT(3)
  • Estrellas Poker Tour(1)
  • Eureka Poker Tour(2)
  • France Poker Series(1)
  • Gift Voucher(1)
  • Golden Nugget Grand Poker Series(0)
  • Grosvenor Casino Coventry(3)
  • Grosvenor Goliath(0)
  • Grosvenor Poker 25/50(30)
  • Grosvenor UK Poker Open(0)
  • Grosvenor's National Poker League(1)
  • GUKPT Grosvenor(3)
  • Hippodrome Casino(1)
  • IPO(1)
  • Irish Poker Festival(1)
  • Irish Poker Open(1)
  • Irish Poker Tour(7)
  • Kings of Tallinn(1)
  • LAPT(2)
  • London Poker Festival(1)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(0)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(5)
  • Moneymaker Tour(3)
  • North American Poker Tour(1)
  • Olympic Park Casino(1)
  • Orleans Summer Open(0)
  • Poker GO Tour(1)
  • Poker Skills Events(0)
  • PokerStars Caribbean Adventure(0)
  • PokerStars Festival(0)
  • PokerStars Summer Series(0)
  • Pure Poker Tour(0)
  • Queens of Tallinn(0)
  • RDS (Royal Dublin Society)(1)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(2)
  • The Caribbean Poker Series(1)
  • The Casino at Portomaso(4)
  • The Festival(2)
  • The Poker Room(0)
  • Triton Super High Roller Series(0)
  • UK Poker Championships(1)
  • UKIPT(1)
  • Unibet DeepStack Open(6)
  • Unibet Open(0)
  • Venetian Deepstack Extravaganza(1)
  • Women's Winter Festival(1)
  • WPT(4)
  • WPT Alpha 8(0)
  • WPT Prime(3)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(11)
  • WSOP International Circuit(4)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(1)
• Featured Venues
• Destination Guides
  • Las Vegas
  • Malta
  • London
  • Dublin
  • Coventry
• About Us
  • About Us
  • Partners
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • The Management
  • Work With Us
  • Event Management
  • Flight FAQs
  • Main Event Dealers Training Schools
  • Enquiry Form
• Promotions
  • Promotions
  • FinalTableFreeroll FTF
  • Main Event Travel Gift Vouchers
  • London Poker Festival FinalTableFreeroll
  • Malta Poker Festival FinalTableFreeroll
  • MPF Autumn 24 VIP Package Giveaway
  • The Killarney Festival FinalTableFreeroll

Login / Register

UK: +44 (0) 1770 280000 | US: +1 (702) 500-1333 info@maineventtravel.com

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

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

Chip Leaders Day 2

1

Linda Nguyen

2,300,000

Day 1 Day 2

Live Updates Chip Counts Structure Gallery Payouts

SHARE

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 info@maineventtravel.com

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Subscribe to our newsletter