0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

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

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.0002 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.0005 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.0010 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.0005 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.0087 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_event9'

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

0.0293 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0059 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '373'
AND `published` = 1

0.0002 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `id` = '373'

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '146'
AND `name` = 'FINAL'

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

0.0053 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` = '373'
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` = '16178'
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` = '16118'
ORDER BY `chip_change` DESC, `busted` ASC

0.0276 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` = '16115'
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` = '16112'
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` = '16106'
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` = '16098'
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` = '16095'
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` = '16093'
ORDER BY `chip_change` DESC, `busted` ASC

0.0072 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` = '16088'
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` = '16096'
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` = '16084'
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` = '16082'
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` = '16080'
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` = '16074'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0071 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` = '16059'
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` = '373'
ORDER BY `busted` ASC, `current_chips` DESC

0.0056 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` = '373'
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` = '16178'
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` = '16118'
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` = '16115'
ORDER BY `chip_change` DESC, `busted` ASC

0.0068 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` = '16112'
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` = '16106'
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` = '16098'
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` = '16095'
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` = '16093'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0080 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` = '16084'
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` = '16082'
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` = '16080'
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` = '16074'
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` = '16069'
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` = '16059'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0004 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(0)
  • APAT(2)
  • APPT(1)
  • Aria Resort & Casino(2)
  • Asian Poker Tour(0)
  • Aspers Casino Westfield Stratford City(3)
  • Battle Of Malta(0)
  • Borgata Poker(0)
  • Bratislava Poker Festival(0)
  • British Poker Series(5)
  • BSOP(1)
  • Costa Rica Poker Festival(1)
  • Dusk Till Dawn(5)
  • EAPT(3)
  • EPT(4)
  • Estrellas Poker Tour(0)
  • Eureka Poker Tour(1)
  • France Poker Series(0)
  • Golden Nugget Grand Poker Series(0)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/50(5)
  • Grosvenor UK Poker Open(0)
  • Grosvenor's National Poker League(1)
  • GUKPT Grosvenor(1)
  • Hippodrome Casino(1)
  • IPO(0)
  • Irish Poker Festival(1)
  • Irish Poker Open(1)
  • Irish Poker Tour(8)
  • Kings of Tallinn(0)
  • Kings of Vilnius(1)
  • LAPT(0)
  • London Poker Festival(0)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(1)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(13)
  • North American Poker Tour(0)
  • OlyBet Showdown(0)
  • Orleans Summer Open(0)
  • Poker GO Tour(1)
  • Poker Skills Events(1)
  • PokerStars Caribbean Adventure(0)
  • PokerStars Festival(0)
  • PokerStars Summer Series(0)
  • Pure Poker Tour(0)
  • Queens of Tallinn(1)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(1)
  • The Caribbean Poker Series(0)
  • The Festival(1)
  • Triton Super High Roller Series(0)
  • UK Poker Championships(1)
  • UKIPT(1)
  • Unibet DeepStack Open(3)
  • Venetian Deepstack Extravaganza(3)
  • Women's Winter Festival(1)
  • WPT(5)
  • WPT Prime(2)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(17)
  • WSOP International Circuit(4)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(0)
• 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
  • Main Event Dealers Training Schools
  • Enquiry Form
• Promotions
  • Promotions
  • FinalTableFreeroll FTF

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 #9: €3,000 No-Limit Hold'em Six-Max Live Reporting - Day FINAL

Olympic Park Casino - Live Reporting

Event #9: €3,000 No-Limit Hold'em Six-Max See other events

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)

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 24 Current Day FINAL

---

Blinds 20,000/40,000 Ante 40000

Entries 100 Remaining 1

---

Prize Pool (EUR) €64,000 First Prize (EUR) €271,600

Chip Leaders Day FINAL

1

Roope Tarmi

5,000,000

Day FINAL

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Live Updates - Day FINAL

Roope Tarmi Crowned WSOPC €3,000 NLH 6-Max Champion Two Years In A Row Posted Sunday 28th July, 2024 at 22:29(UTC+2) by Alaxandar Georgiev

Last September Roope Tarmi Managed to win the same event and got his first ring and the prize of €78,200 - this year the Finn managed to defend his title and win it once again for €64,000. What an amazing accomplishment this is, beating the toughest field two years in a row and both golden rings.

Roope was chip-leading by a bit when it was down to 4 people and somehow knocked them out in 3 hands in a row. The action was crazy, he made a massive cooler against the other big stack and he won two flips to secure himself the victory at the end. Tarmi played brilliantly in the tournament and he was also very close to winning another ring two days ago when he came 3rd in the €555 NLH. 

Place	Player	Country	Prize + Bounties
1	Roope Tarmi	Finland	€64,000
2	Erik Lindqwist	Sweden	€44,500
3	Paulius Vaitiekunas	Lithuania	€33,500
4	Ekrem Atush	Finland	€25,700
5	Luka Sorainen	Finland	€19,900
6	Janne Nevalainen	Finland	€15,400
7	Elias Suhonen	Finland	€12,400

Roope Tarmi Wins The Highroller Gold In Just Three Hands (€64,000) Posted Sunday 28th July, 2024 at 14:48(UTC+2) by Alaxandar Georgiev

Roope Tarmi is the WSOPC €3,000 NLH 6-Max Ring Event #9  Champion !!!

He managed to win the Highroller in just three huge hands in a row. First, he cracked Ekrem Atush's pocket Kings with his sevens in a post-flop action. Then he won a flip with his against Paulius Vaitiekunas's pocket tens and next he won the reverse flip against Erik Lindqwist's with his pocket sevens.

This is Roope's second big finish this year in the WSOP Circuit here in Tallinn. He also finished 3rd in the 555 NLH Ring Event. 

This time he wins it all, the Finn gets the big prize of €64,000 and of course the wanted-by-many Highroller WSOPC Golden Ring.

2nd Place For Erik Lindqwist (€44,500) Posted Sunday 28th July, 2024 at 14:28(UTC+2) by Alaxandar Georgiev

Level 24: 20,000/40,000 (40,000)
Entries 2/100

Roope Tarmi limped from the small blind and got raised to 125,000 from Erik Lindqwist, Tarmi then put him all-in and Lindqwist quickly called. Roope had just busted two players in the last two hands and the third hand was already an all-in. Lindqwist had roughly 700,000 while his Finnish opponent had slightly more than four million chips.

Erik Lindqwist:
Roope Tarmi:

Once again Tarmi had his lucky sevens and he got a pretty good flop. Lindqwist's hopes of winning the WSOPC Highroller Golden Ring shrank a little further on the turn. 

Lindqwist needed only an Ace or a King to stay in the heads-up and the river came brick.

The Swede started the day as the big chip leader but finished just short of the golden prize. Erik Lindqwist will take €44,500 for his 2nd place.

Player		Chips	Progress
Roope Tarmi		5,000,000	600,000
Erik Lindqwist		0	0

3rd Place Finish For Paulius Vaitiekunas (€33,500) Posted Sunday 28th July, 2024 at 14:13(UTC+2) by Alaxandar Georgiev

Level 24: 20,000/40,000 (40,000)
Entries 3/100

The action started with an 80,000 raise from Erik Lindqwist and a three-bet by Paulius Vaitiekunas to 375,000 from the small blind. Roope Tarmi then put them both all in to call with his massive stack. Lindqwist folded and the Lithuanian called off for his remaining 350,000.

Paulius Vaitiekunas:
Roope Tarmi:

There we go another flip on the final table, very important for both players. The flop came in Tarmi's way as he hit a pair of Kings. Nobody had a flush draw and the popped on the turn. 

The river was the and it was over for the Lithuanian, he busts too close to the golden ring and will take a payout of €33,500 for his 3rd place finish.

Player		Chips	Progress
Roope Tarmi		4,400,000	900,000
Paulius Vaitiekunas		0	0

Ekrem Atush Goes Out In 4th place (€25,700) After Losing A Massive Pot Posted Sunday 28th July, 2024 at 13:59(UTC+2) by Alaxandar Georgiev

Level 24: 20,000/40,000 (40,000)
Entries 4/100

Roope Tarmi opened the action and Ekrem Atush three-bet him to 200,000 - the shorter stacks on the blinds folded and the two chip leaders went to the flop.

Tarmi checked first and his opponent bet another 200,000 which he called. The turn was the and this is where things got heated. Another check from Tarmi and a huge 550,000 bet from Atush, followed by an all-in and a call for about a million chips on the turn.

This was a massive pot worth over 3,000,000 chips.

Ekrem Atush:
Roope Tarmi:  

Tarmi had it almost locked in with his flopped full-house, he had hit one of the other two sevens in the deck and had Atush's Kings cracked. The river was and Roope Tarmi Scoops the massive pot. He now has almost 80% of the chips in play.

Ekrem Atush left the table seemingly disappointed after the bad beat and collected €25,700. fo

Player		Chips	Progress
Roope Tarmi		3,500,000	2,100,000
Ekrem Atush		0	0

13:33 (UTC+2)

Start of Level 24
Blinds: 20,000/40,000     Ante: 40,000

Sorainen Is Eliminated in 5th place (€19,900) Posted Sunday 28th July, 2024 at 13:28(UTC+2) by Alaxandar Georgiev

Level 23: 15,000/30,000 (30,000)
Entries 5/100

Luka Sorainen opened the pot to 60,000 and Roope Tarmi defended his big blind. The flop came ace high and Sorainen continued for another 60,000 after a check from his opponent.

The turn was the on which both players checked. And the river was another small card - Roope Tarmi tanked for a while before announcing that he was all-in, a few moments later Sorainen flicked in the call. 

Luka Sorainen:
Roope Tarmi:

Sorainen had a pretty good hand, but his top pair was no bueno against Tarmi's two pair. He is eliminated in 5th place with a payout of €19,900.

Player		Chips	Progress
Roope Tarmi		1,400,000	500,000
Luka Soralnen		0	0

Chip Count Update In Top 5 Posted Sunday 28th July, 2024 at 13:21(UTC+2) by Alaxandar Georgiev

Level 23: 15,000/30,000 (30,000)
Entries 5/100

Only five are left to play for the big money up top and the WSOPC Golden Ring. Check out their respective stacks down below.

Name	Country	Stack
Erik Lindqwist	Sweden	1,600,000
Ekrem Atush	Finland	1,400,000
Roope Tarmi	Finland	775,000
Paulius Vaitiekunas	Lithuania	680,000
Luka Sorainen	Finland	670,000

Nevalainen Finishes In 6th Place (€15,400) Posted Sunday 28th July, 2024 at 13:12(UTC+2) by Alaxandar Georgiev

Level 22: 10,000/25,000 (25,000)
Entries 6/100

Janne Nevalainen jammed for about 450,000 and Roope Tarmi Isolated. It was a big pot for both and the winner would be amongst the chip leaders.

Janne Nevalainen:
Roope Tarmi:

The flop created some tension as Nevalainen was now drawing to a flush as well. The turn was revealed shortly and didn't change much.

No luck on the fifth card for Nevalainen and he busts in 6th place.

A good run in the Highroller for Janne Nevalainen, he will be taking home a €15,400 payout.

Player		Chips	Progress
Roope Tarmi		900,000	380,000
Janne Nevalainen		0	0

13:05 (UTC+2)

Start of Level 23
Blinds: 15,000/30,000     Ante: 30,000

Elias Suhonen is Eliminated in 7th place (€12,400) Posted Sunday 28th July, 2024 at 12:57(UTC+2) by Alaxandar Georgiev

Level 22: 10,000/25,000 (25,000)
Entries 7/100

Elias Suhonen was down to his last five blind and put three of them as a raise, he got caled by Ekrem Atush on the button and the other players folded.

The flop came - Suhonen checked and called off his last 2 blinds and they went to showdown.

Elias Suhonen:
Ekrem Atush:

Suhonen was dominated and needed to hit one of his queens to stay in the tournament. The turn and river both bricked for him and his hopes of wining the Highroller ring were finished.

Elias Suhonen finishes in 7th place and will take home a payout of €12,400.

Player		Chips	Progress
Ekrem Atush		1,200,000	640,000
Elias Suhonen		0	0

Big Double Up For Sorainen Posted Sunday 28th July, 2024 at 12:50(UTC+2) by Alaxandar Georgiev

Level 22: 10,000/25,000 (25,000)
Entries 7/100

Luka Sorainen raised first to 50,000 off from a short stack and got called by Roope Tarmi on the big blind, flop came and Sorainen continued for 40,000 after a check. Tarmi put a big pile of chips in the middle and put him all in - snap call and we went to showdown:

Luka Sorainen:
Roope Tarmi:

Sorainen hit his set on the turn and his opponent started counting chips for the payout. Sorainen had 230,000 behind and is now up to 595,000 chips.

Player		Chips	Progress
Luka Soralnen		595,000	329,000
Roope Tarmi		520,000	235,000

Shuffle Up And Deal Posted Sunday 28th July, 2024 at 12:29(UTC+2) by Alaxandar Georgiev

Level 21: 10,000/20,000 (20,000)
Entries 7/100

The last seven players took their seats and their names and chip counts were announced by our tournament director. It is time to start the battle for the Highroller golden ring. The average stack on the final table is 714,000 and the next pay jump is a nice sum of €3,000.

Erik Lindqwist from Sweden leads the way with over two million chips, let's see if he can use this to his advantage and take the jewelry.

12:13 (UTC+2)

Day FINAL of Olympic Park Casino Started
Level: 21     Blinds: 10,000/20,000     Ante: 20,000

Welcome to Day 2 Of The #9 WSOPC €3,000 NLH Ring Event Posted Sunday 28th July, 2024 at 11:20(UTC+2) by Alaxandar Georgiev

The WSOPC €3,000 NLH Ring Event #9 got a total of 100 entries yesterday and it played down to the final table. The 6-max event has only 7 players left and they will battle it out for the glory, the money and of course the golden ring that comes with taking the first place.

Here is the final table seat draw and chip counts.

Seat	Name	Country	Chips	Big Blinds
1	Roberto Olsen	Finland	560,000	46
2	Luka Sorainen	Finland	266,000	23
3	Erik Lindqwist	Sweden	2,134,000	22
4	Paulius Vaitiekunas	Lithuania	714,000	13
5	Janne Nevalainen	Finland	380,000	13
6	Roope Tarmi	Finland	755,000	79
7	Elias Suhonen	Finland	192,000	47

Sweden's Erik Lindqwist is leading the way with a massive stack of over two million. He has to fight for the ring with not one, but five Finns and Lithuania's Paulius Vaitiekunas who already has three rings and he just won a tournament in the Triton series this year.

Roope Tarmi is also in the house, he finished 3rd in Ring Event #3: €555 NLH and took down a score of €25,100. He is now on his second final table for the series and hunting another ring.

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