0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0057 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-07-27' AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event8' ORDER BY `views` DESC

0.4718 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-07-27' AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event8'

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.0001 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.0009 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.0010 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.0843 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.0005 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_event8'

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

0.0355 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0553 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '361' AND `published` = 1

0.1115 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0222 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '367' AND `published` = 1

0.0060 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `id` = '367'

0.0004 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '144' AND `name` = '2'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0064 SECONDS:
SELECT * FROM `tour_stop_blogs` WHERE `active` = 1 AND `tour_stop_id` = 2553

English
Olympic Park Casino Event #8: €1,100 NLH Mystery Bounty Live Reporting - Day 2
1 New Update - Click to refresh
Live Updates - Day 2
Egidijus Digrys is Eliminated in 9th (€2,500) Posted Saturday 27th July, 2024 at 15:35(UTC+2) by Alaxandar Georgiev

Level 23: 10,000/25,000 (25,000)
Entries 9/218

Egidijus Digrys raised 75,000 off from his 400,000 stack and got effectively jammed by Arduini Lorenzo who was on the button. Digrys called and they revealed their cards.

Egidijus Digrys:
Arduini Lorenzo:

Digrys was ahead and needed to fade some aces after the flop. The turn was another diamond, which gave Lorenzo too many additional outs for a flush and a gutshot straight. The river was the which meant it was the end for Digrys in the golden ring race.

Egidijus Digrys finished in 9th place and he won 0 bounties, he will collect a payout of €2,500.

Player Chips Progress
Arduini Lorenzo 1,750,000 155,000
Egidijus Digrys 0 0
Can The Shortest Stack Double Up? Posted Saturday 27th July, 2024 at 15:29(UTC+2) by Alaxandar Georgiev

Level 23: 10,000/25,000 (25,000)
Entries 9/218


Rasmus Lundstrum was all-in for his last 70,000 chips and got two calls, one of them from Albert Ostrovskij on the big blind who bet the

Rasmus Lundstrum:
Albert Ostrovskij:

Lundstrum needed only a queen to stay alive after his opponent had already paired his eight. The turn was and with only one card to go Lundstrum hit the on the river and tripled up.

Player Chips Progress
Albert Ostrovskij 600,000 80,000
Rasmus Lundstrom 245,000 175,000
15:21 (UTC+2)
Start of Level 23
Blinds: 10,000/25,000     Ante: 25,000
Final Table Seat Draw And Chip Counts Posted Saturday 27th July, 2024 at 15:17(UTC+2) by Alaxandar Georgiev

Check out the players who made it to the final table of the Ring Event #8 WSOPC €1,100 NLH Mystery Bounty.

The big chip leader is Finland's Akseli Paalanen with just a bit over two million chips, right behind is Arduini Lorenzo and everyone else is short compared to these two. Rasmus Lundstrum and Klaudijus Bajoras are left with just a few blinds and they need to spin it up.

Name Country Chip count Seat
Arduini Lorenzo Italy 1,595,000 18-5
Egidijus Digrys Lithuania 350,000 18-9
Rasmus Lundström Finland 70,000 18-1
Akseli Paalanen Finland 2,035,000 18-8
Klaudijus Bajoras Lithuania 110,000 18-2
Albert Ostrovskij Lithuania 680,000 18-6
Oleksii Natoptanyi Ukraine 570,000 18-7
Ritvars Cekalins Latvia 425,000 18-4
Claudio Cecchi Italy 705,000 18-3

Players Who Busted Right Before FT Posted Saturday 27th July, 2024 at 15:04(UTC+2) by Alaxandar Georgiev

Here is the list of players who fell short of making it into the final table. 

Phil Gross got an ugly setup against one of the players where he had two pairs on the flop and his opponent had a made straight. He falls short of making it into another WSOPC Final table after winning his first golden ring just 2 days ago.

Place Name Country Prize + Bounties
10 Josep Ramon Spain €10,150
11 Phil Gross Germany €3,100
12 Anti Reinthal Estonia €1,900
13 Mikael Haapaniemi Finland €2,900
14 Pavels Kazakovs Latvia €2,650
Player Chips Progress
Josep Pastor De Ramon 0 0
Phil Gross 0 0
Anti Reinthal 0 0
Mikael Haapaniemi 0 0
Pavels Kazakovs 0 0
Josep Ramon Bubbles The Final Table Posted Saturday 27th July, 2024 at 14:56(UTC+2) by Alaxandar Georgiev

Level 20: 10,000/20,000 (20,000)
Entries 10/218

Josep Ramon was left with a few blinds after he lost his last hand and decided to go for it with from the big blind after a raise by Arduini Lorenzo. No luck for Ramon till the river, he finished in 10th place just one away from the final table.

Ramon will take home €2,500 and his €8,000 bounty he drew earlier.

Player Chips Progress
Arduini Lorenzo 1,700,000 1,270,000
Josep Pastor De Ramon 0 0
Karlsson And Cekalins Picks Up The Big Ones In The Raffle! Posted Saturday 27th July, 2024 at 14:51(UTC+2) by Lina Olofsson

And just like that we are down to the last ten players and already had the first break of the day which also meant raffle time. Several players got to join the raffle action. 

All players from now on get a bounty chip for each player they eliminate and get to stick their hand into the big box of envelopes which contains some huge numbers. The minimum amount they will say €500 and then it's all the way up to the €20,000 one lucky winner will receive. And it's already out there! 

Steinn Thanh Du Karlsson was the first one to reach into those envelopes and he did a very good job picking up the highest amount of them all. He only had one bounty chip and managed to pick just the right one. As soon as the game resumed he was eliminated but still picked up more than the first price in the tournament cashing in €21 650 in total for his efforts here. 

Just after Steinn had plucked his 20,000 win it was time for Ritvars Cekalins and he did a really good job too cashing in €10,000 which there are three of in total amongst all these 27 envelopes. 

Double On The FT Bubble Posted Saturday 27th July, 2024 at 14:50(UTC+2) by Alaxandar Georgiev

Level 20: 10,000/20,000 (20,000)
Entries 10/218

Ritvars Cekalins shoved his over a raise on the final table bubble, he had 234,000 chips and got called behind by another all-in player Josep Ramon, who had 345,000.

Ramon didn't manage to make a pair till the river and is down to 110,000 chips.

Player Chips Progress
Ritvars Cekalins 640,000 455,000
Josep Pastor De Ramon 110,000 151,000
14:35 (UTC+2)
Start of Level 21
Blinds: 10,000/20,000     Ante: 20,000
The Most Disgusting Hand In Day 2 Posted Saturday 27th July, 2024 at 14:32(UTC+2) by Alaxandar Georgiev

Level 20: 10,000/15,000 (15,000)
Entries 12/218

Raise from Albert Ostrovskij and a call from Rasmus Lundstrum on the big blind saw them both go on the flop where Lundstrum check-raised his opponent's 40,000 bet to 115,000 and Ostrovskij re-shoved for 488,000 which was snap-called by Lundstrum.

Rasmus Lundstrum: - Set of threes
Albert Ostrowskij: - top pair, top kicker

Ostrowskij seemed surprised when he saw his opponent's hand, he got some hopes when the dealer put the on the turn which meant he was now drawing for a full house. 

BANG... the river was another ace and Lundstrum couldn't believe it... he said "I want to cry .. " as he started counting the chips for the massive payout he had to give to Ostrovskij, Lundstrum was left with about 130,000 after the sick hand.

Rasmus Lundstrum

Player Chips Progress
Albert Ostrovskij 1,020,000 450,000
Rasmus Lundstrom 130,000 60,000
Last Two Tables Posted Saturday 27th July, 2024 at 14:10(UTC+2) by Alaxandar Georgiev

Level 20: 10,000/15,000 (15,000)
Entries 14/218

There was a re-draw for the last two tables after another few players busted, we will soon be on the final table if players continue going crazy for bounties. But a lot of the big bounties have already been taken, let's see how players adjust to this situation.

Here is a list of the people who busted in the money.

Player Chips Progress
Steinn Thanh Du Karlsson 0 0
Nidal Dawoud 0 0
Vidar Assersen 0 0
Massimo Casabona 0 0
Mikko Salmij?rvi 0 0
Ryhor Karapanau 0 0
Frederic Delval 0 0
Sven Stok 0 0
Morten Bremseth 0 0
Jaakko Ranua 0 0
Ricardas Lukauskas 0 0
Ekrem Esker Atush 0 0
Elvijs Kuceruks 0 0
Gross Gives People A Ride With His Q7 Posted Saturday 27th July, 2024 at 14:03(UTC+2) by Alaxandar Georgiev

Level 20: 10,000/15,000 (15,000)
Entries 17/218

Arduini Lorenzo opened up the pot from an early position and got a call from Rasmus Lundstrom for 30,000 chips. Then we had the main aggro player Phil Gross who recently won a WSOPC Ring shove for 332,000 and only Lorenzo called after some thinking. 

Phil Gross:
Arduini Lorenzo:

Phil was feeling great when he saw his opponent's hand and even better on the flop. He managed to hit a pair and held it through the next two cards. Huge pot worth about 700,000 chips goes Phil's way.

Phil got another huge one against blind on blind a few hands later when he won against . Phil drilled a Jack on the flop and got his first Mystery Bounty.

Player Chips Progress
Phil Gross 710,000 210,000
Arduini Lorenzo 430,000 312,000
Ricardas Lukauskas 0 0
Huge Hand On Table 18 Posted Saturday 27th July, 2024 at 13:53(UTC+2) by Alaxandar Georgiev

Level 20: 10,000/15,000 (15,000)
Entries 18/218

Pavels Kazakovs raised under the gun,  Arduini Lorenzo, and Phil Gross called the 30,000 raise and Albert Ostrovskij shoved it from the big blind for 175,000. Kazakovs re-shoved and Lorenzo called for a big pot.


Albert Ostrovskij:
Arduini Lorenzo:
Pavels Kazakovs:

Ostrovskij was favorite to triple-up and the flop was clean for him. The turn and river didn't change anything for the pocket pairs.

Ostrovskij  wins a massive pot worth over 550,000 and Lorenzo had 371,000 behind for the side pot, so even though he lost the main pot he is still up in chips.

Player Chips Progress
Arduini Lorenzo 742,000 145,000
Albert Ostrovskij 570,000 328,000
Pavels Kazakovs 90,000 302,000
13:45 (UTC+2)
Start of Level 20
Blinds: 10,000/15,000     Ante: 15,000
Oleksii Natoptanyi Is Short Of Luck Posted Saturday 27th July, 2024 at 13:42(UTC+2) by Alaxandar Georgiev

Level 19: 6,000/12,000 (10,000)
Entries 19/218

Oleksii Natoptanyi shoved his last 90,000 in the middle and Ekrem Atush re-jammed from the small blind.

Oleksii Natoptanyi:
Ekrem Atush:

The flop was safe for the Ukrainian, the dealer then put the on the turn and Atush was now a card away from a mystery bounty envelope. The river was a brick and it ended Natoptanyi's run in the tournament in 19th place and €1,350.

Another One Bites The Dust Posted Saturday 27th July, 2024 at 13:27(UTC+2) by Alaxandar Georgiev

Level 19: 6,000/12,000 (10,000)
Entries 22/218

Egidijus Digrys opened under the gun and Ryhor Karapanau only had 2 blinds left he called the raise and was all in. 3 more calls were followed behind by Mikael Haapaniemi in the middle, Rasmus Lundström, and Josep Ramon completed from the blinds.

The flop was two checks and action was on Digrys who bet 36,000 - only Lundstrom called and they both checked the turn. The river was and Lundstrom checked once again, which led to Digrys betting 60,000 and Lundstrom snap-calling.

Egidijus Digrys:
Ryhor Karapanau:
Rasmus Lundström:

Lundstrom wins a sweet pot and his first Mystery Bounty, Karapanau finished the tournament in 21st place and will take home €1,250.

Player Chips Progress
Rasmus Lundstrom 540,000 146,000
Egidijus Digrys 200,000 163,000
Ryhor Karapanau 0 0
13:14 (UTC+2)
Start of Level 19
Blinds: 6,000/12,000     Ante: 12,000
Big River For Assersen Posted Saturday 27th July, 2024 at 13:14(UTC+2) by Alaxandar Georgiev

Level 18: 5,000/10,000 (10,000)
Entries 25/218

Vidar Assersen shoved for his remaining 50,000 chips and Iceland's Steinn Karlsson had him covered right on his left with his 72,000 chips, on the big blind Egidijus Digrys was sitting with a big stack of more than 400,000 and also flicked in the call to play for the bounties.

Vidar Assersen:
Steinn Karlsson:
Egidijus Digrys:

Assersen had the best hand and was very likely to triple up on the flop. Digrys could now hit a six for the win as well, the turn changed nothing, but it was very bad news on the river for Assersen's pocket queens.

Steinn Karlsson wins the bounty and a good pot at start of Day 2.

Player Chips Progress
Egidijus Digrys 363,000 72,000
Steinn Thanh Du Karlsson 195,000 170,000
Vidar Assersen 0 0
13:01 (UTC+2)
Day 2 of Olympic Park Casino Started
Level: 18     Blinds: 5,000/10,000     Ante: 10,000
Shuffle Up And Deal !! Posted Saturday 27th July, 2024 at 13:01(UTC+2) by Alaxandar Georgiev

Level 18: 5,000/10,000 (10,000)
Entries 27/218

Players just took their seats, opened their bags and the chips were on the table.  The top bounty prize is the whopping amount of  €20,000 and its almost as much as the first place prize which is €21,430, so one lucky guy could potentially win more than the player who wins the tournament.

Follow this live blog for more updates through the final day of the WSOPC €1,100 NLH Mystery Bounty Ring Event.

Historical Mystery Bounty In Tallinn About To Start Posted Saturday 27th July, 2024 at 12:54(UTC+2) by Lina Olofsson

Records after records are broken here as the prestigious WSOP Circuit visits Tallinn for the second time. As the registration closed in the €1,100 Mystery Bounty after ten levels there had been 218 entries made in total creating a prize pool of €209,280 with a first prize of €21,430. 

As the tournament clock stopped here pretty late last night on the 18th level the remaining players were down to the last 27 which means that when we come back we are not only in the money. So is the mystery bounty where one lucky player will receive an astonishing €20,000, one will receive €15,000 and in three of these envelopes there will be €10,000. 

In each break, there will be a mystery bounty raffle for the players who managed to pick up some bounties which the blog obviously will stick around to see and report back to you. 

Chip leader going into today is Arduini Lorenzo from Italy with 597,000. Second in chips, we have the Finn Mikael Haapaniemi with 563,000 and the third is the event three winner Phil Gross with 500,000. 

Play resumes at 1 pm. Shuffle up and deal! 

The Event #3 winner Phil Gross is excited to start! 

Day 2 Seat Draw Posted Saturday 27th July, 2024 at 11:36(UTC+2) by Jason Glatzer
Table Seat Name Country Chips Big Blinds
16 1 Jaakko Ranua Finland 45,000 5
16 3 Massimo Casabona Italy 69,000 7
16 4 Josep Pastor De Ramon Spain 261,000 26
16 5 Klaudijus Bajoras Lithuania 266,000 27
16 6 Ekrem Esker Atush Finland 97,000 10
16 7 Phil Gross Germany 500,000 50
16 8 Mikael Haapaniemi Finland 563,000 56
17 1 Akseli Paalanen Finland 338,000 34
17 2 Oleksii Natoptanyi Ukraine 241,000 24
17 3 Mikko Salmijärvi Finland 192,000 19
17 4 Nidal Dawoud Denmark 61,000 6
17 5 Anti Reinthal Estonia 255,000 26
17 7 Sven Stok Netherlands 458,000 46
17 8 Ritvars Cekalins Latvia 185,000 19
18 1 Elvijs Kuceruks Latvia 72,000 7
18 3 Morten Bremseth Norway 163,000 16
18 4 Ricardas Lukauskas Lithuania 156,000 16
18 5 Albert Ostrovskij Lithuania 242,000 24
18 6 Pavels Kazakovs Latvia 392,000 39
18 7 Arduini Lorenzo Italy 597,000 60
18 8 Frederic Delval France 92,000 9
23 1 Egidijus Digrys Lithuania 435,000 44
23 2 Ryhor Karapanau Latvia 190,000 19
23 3 Claudio Cecchi Italy 168,000 17
23 4 Vidar Assersen Norway 72,000 7
23 6 Steinn Thanh Du Karlsson Iceland 25,000 3
23 7 Rasmus Lundström Finland 394,000 39

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.