0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

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

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

0.0005 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.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'page'

0.0072 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.0004 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` = 'wsopctallinn_2023_event6'

0.0002 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '33'

0.0710 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0067 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '102' AND `published` = 1

0.0826 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0073 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '125' AND `published` = 1

0.0870 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0081 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '129' AND `published` = 1

0.0837 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0067 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '130' AND `published` = 1

0.0277 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0058 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '132' AND `published` = 1

0.0845 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0077 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '135' AND `published` = 1

0.0821 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0077 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '138' AND `published` = 1

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

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

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

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

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

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

0.0610 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` = '5647' 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` = '5645' 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` = '5644' 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` = '5641' ORDER BY `chip_change` DESC, `busted` ASC

0.0712 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` = '5639' 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` = '5638' 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` = '5633' 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` = '5631' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0058 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` = '5628' 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` = '5627' 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` = '5624' 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` = '5621' 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` = '5617' 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` = '5615' 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` = '5614' 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` = '5610' ORDER BY `chip_change` DESC, `busted` ASC

0.0566 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` = '5608' 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` = '5598' 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` = '5596' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

0.0564 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` = '5649' 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` = '5647' 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` = '5645' 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` = '5644' 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` = '5641' 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` = '5639' 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` = '5638' 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` = '5633' 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` = '5631' ORDER BY `chip_change` DESC, `busted` ASC

0.0571 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` = '5629' 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` = '5628' 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` = '5627' 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` = '5624' 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` = '5621' 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` = '5617' 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` = '5615' 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` = '5614' ORDER BY `chip_change` DESC, `busted` ASC

0.0559 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` = '5610' 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` = '5608' 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` = '5598' 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` = '5596' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0003 SECONDS:
SELECT * FROM `tour_stop_blogs` WHERE `active` = 1 AND `tour_stop_id` = 2143

English
WSOPC Tallinn Event #6: €1,500 WSOPC Tallinn Main Event Live Reporting - Day 4
1 New Update - Click to refresh
Live Updates - Day 1D
Eemil Tuominen Bags Day 1d Chip Lead Posted Thursday 21st September, 2023 at 23:26(UTC+0) by Jason Glatzer

Day 1d added another 111 entries to the mix to bring the total up to 617 entries in the WSOPC Tallinn €1,500 Main Event. This figure will continue to grow as players can still late-register and re-enter during the first two blind levels of Friday's Day 2 which kicks off at noon.

Finland's Eemil Tuominen was the only player in the Day 1d flight to find a bag north of 200,000. Check out all of the chip counts from Day 1d below:

Player Chips Big Blinds
Eemil Tuominen 242,000 97
Jarmo Salonen 189,000 76
Henri Antikainen 165,000 66
Ingus Arajs 161,000 64
Vasilij Barna 154,000 62
Max Avela 152,000 61
Antti Veerberk 147,000 59
Khalid Dghaim 146,000 58
Albert Gorelik 145,000 58
Arturs Sutens 137,000 55
Eedi Kirves 134,000 54
Richard Koppel 127,500 51
Karl Relander 115,000 46
Julian Selinger 114,000 46
Joshua Marquardt 114,000 46
Karolis Kutkauskas 112,000 45
Christopher Berggren 109,500 44
Elias Vaaraniemi 104,500 42
Emanuele Mari 100,000 40
Giovanni Memola 99,500 40
Atte Franssila 99,000 40
Aleksandr Arutjunov 99,000 40
Kalle Salmela 98,500 39
Christoffer Bering 98,000 39
Steven Tool 93,500 37
Jari-Pekka Juhola 93,000 37
Konsta Heikkila 92,000 37
Benjamin Dixon 87,000 35
Ranno Sootla 84,000 34
Marek Selgeveer 84,000 34
Martin Koppl 83,000 33
Baavo Pohlak 82,500 33
Martin Piik 82,000 33
Jeffrey Sarwer 80,000 32
Egon Kaljulaid 75,500 30
Vladimiras Meckovskis 74,500 30
Rikard Relander 74,000 30
Jyrki Lampinen 73,500 29
Luca Beretta 73,500 29
Johan Karlsson 71,000 28
Rasmus Lundstrom 69,500 28
Anna-Mari Hursti 66,500 27
Vincas Tamasauskas 65,000 26
Saku Turtia 65,000 26
Martin Lategui 63,000 25
Justas Semaska 57,500 23
Mairo Tori 57,500 23
Teemu Sanaksenaho 57,500 23
Tomi Bondarew 55,000 22
Roope Holma 52,000 21
Janne Havio 50,000 20
Verneri Sivula 49,500 20
Joel Ylismaki 48,500 19
Charles-Eric Benoit 39,500 16
Herli Olop 36,500 15
Danel Kunman 36,000 14
Kaido Kuusemae 34,000 14
Inigo Serrano Robles 31,500 13
Juho Sallinen 30,000 12
Kalle Parkkinen 29,500 12
Tomas Molcan 27,000 11
Markku Koplimaa 26,000 10
Jose Koistinen 17,500 7
Stay Tuned for the Chip Counts! Posted Thursday 21st September, 2023 at 22:36(UTC+0) by Lina Olofsson

As the players bags their chips we wait for the official counts from the tournament staff. 

Stay tuned to the blog to see the full one as soon as we lay our hands on it. Until then check out today's pictures in the Gallery or go to Olybet.tv to see the results from all of the side events going on here at the same time as the Main Event.

Last Five Hands! Posted Thursday 21st September, 2023 at 22:32(UTC+0) by Lina Olofsson

The clock stopped here at 09:43 minutes left of level 10 and the tournament director announced we are playing the last five hands for today and then the remaining players will bag their chips before it all resumes again tomorrow at noon. 

66 players remain of the 110 entries made in the 1D flight but as we already said you can buy in until the tournament starts again at noon tomorrow. 

Chess Genius Jeff Sarwer in the Main Event Posted Thursday 21st September, 2023 at 22:26(UTC+0) by Lina Olofsson

Level 10: 1,000/2,000 (2,000)
Entries: 67/110

The chess protege Jeff Sarwer hasn't been seen for quite some time now as he popped up as one of the familiar faces in the Main Event sitting over at table ten together with some other familiar faces as Ranno Sootla, Vasilij Barna, and Johan Karlsson. 

Last Chance to Satellite into the Main Event with 15 Seats Guaranteed Posted Thursday 21st September, 2023 at 22:21(UTC+0) by Lina Olofsson

The last satellite to the €1,500 Main Event here in the WSOPC Tallinn is about to start with a huge overlay as only 26 players are in and there's a 15-seat guarantee in this turbo satellite. If you are here in Tallinn, rush down (or up) to the casino for the last chance to grab a seat in this tournament with a guaranteed prize pool of €1 million.

Last Level of Tonight Posted Thursday 21st September, 2023 at 22:17(UTC+0) by Lina Olofsson

We're on the last level of the night with 69 players remaining of the 110 entries made in this flight. The blinds are now up to 1,000/2,000 with a big blind ante of 2,000. 

Player Chips Progress
Johan Karlsson 77,000 0
Armend Sahiti 0 0
22:14 (UTC+0)
Start of Level 10
Blinds: 1,000/2,000     Ante: 2,000
Karlsson: "I didn't even see the flush" Posted Thursday 21st September, 2023 at 21:56(UTC+0) by Lina Olofsson

Level 9: 1,000/1,500 (1,500)
Entries: 69/110

Just before going to the break Johan Karlsson found himself in a difficult decision against Armend Sahiti. Before the flop Sahiti hade raised and Karlsson had pushed it up even further leaving 19,1K when the two saw the flop . Sahiti who had flat called pre flop pushed all-in for 22k and Karlsson tanked for quite a while before making the call. 

Sahiti:
Karlsson:

Sahiti had an open-ended straightdraw and the on the turn gave him the nut straight but the on the river gave Karlsson the nut flush and the pot of 60,000. 

"Wait, what happened there? Did I get a flush?", Karlsson commented as the dealer pushed the pot over to him. "Wow, I only saw his straight there", said Karlsson and swiped away the sweat on his forehead as he laughed: "Nice". 

The pot left the good old King's of Tallinn winner with a comfortable 118,000 going to the last break of the day until we have one more hour to go. 

 

Player Chips Progress
Johan Karlsson 77,000 0
Armend Sahiti 0 0
21:47 (UTC+0)
Start of Level 9
Blinds: 1,000/1,500     Ante: 1,500
Last Break for Tonight Posted Thursday 21st September, 2023 at 21:47(UTC+0) by Lina Olofsson

The players are on their last break of tonight here in the fourth and last flight in the WSOPC €1,500 Main Event. 79 out of the 110 entries still have chips in front of them and we picked up some notable stacks and names as they were away which you can below. 

Swedens Christopher Berggren seems to be the chip leader with 192,000 in his stack even though he lost that big pot against Massimo Casabona (pictured below) a little bit earlier tonight.

Player Chips Progress
Christopher Berggren 192,000 137,000
Jarmo Juhani Salonen 155,000 105,000
Max Avela 143,000 93,000
Jari-Pekka Juhola 138,000 28,000
Gianpaolo Memola 127,000 77,000
Rasmus Lundstrom 116,000 66,000
Vasilij Barna 112,500 62,500
Roope Holma 105,000 55,000
Saku Turtia 92,500 42,500
Vincas Tamasauskas 88,000 38,000
Jeff Sarwer 51,000 1,000
Alexander Selinger 50,000 0
Last Two Levels of the Day Posted Thursday 21st September, 2023 at 21:03(UTC+0) by Lina Olofsson

We are on the last two levels of day 1D and 81 players remain from the field of 108. 

One of the players who fired a bullet both in this field and in day 1C was the former WSOP finalist from back in the day is Swede Erik Friberg who we haven't seen playing for a while now. Welcome back, Erik! 

Pictures from Day 1D Posted Thursday 21st September, 2023 at 20:58(UTC+0) by Lina Olofsson

Here are some pictures from the fourth starting day here in the WSOPC €1,500 Main Event from our brilliant photographer Tambert Kask. All of the pictures from the Main Event you'll find in the gallery above. 

Photographer Elena Kask

Kristopher Kuusk

Martin Koppl

Kaljulaid Keito

Eedi Kirves

Hanno Kerem

Kristopher Kuusk

Massimo Casabona

Vladimiras Meckovskis

Niklas Mikael Vakkuri

Janne Olavi Havio

Verneri Topias Sivula

20:47 (UTC+0)
Start of Level 8
Blinds: 600/1,200     Ante: 1,200
Karlsson Builds His Stack Posted Thursday 21st September, 2023 at 20:47(UTC+0) by Lina Olofsson

The former Kings of Tallinn winner Johan Karlsson decided to join the action and booked a flight here yesterday. He's also one of the players in day 1D and after playing some small ball poker he's built his stack to 77,000 as we reach the end of the event out of ten levels here tonight. 

Player Chips Progress
Johan Karlsson 77,000 27,000
Over 100 Players in the Last Flight Posted Thursday 21st September, 2023 at 20:42(UTC+0) by Lina Olofsson

We are now over 100 players with a couple of hours left of the first day here in day 1D. We still haven't reached the guaranteed prize pool of €1 million and there's still time to buy in until the play starts tomorrow at noon. 

Casabona Doubles through Berggren Posted Thursday 21st September, 2023 at 20:31(UTC+0) by Lina Olofsson

On the last hand of the last level three players saw the flop . The three musketeers was Sweden's Christopher Berggren, Lithuanian WSOP bracelet winner Vincas Tamasauskas and Italian Massimo Casabona. 

Tamasauskas lead out 3,200 which was called by Casabona and Berggren decided to pop it up to 12,000. Tamasauskas went out of the way while Casabona pushed all-in for 33,000. After some consideration, Berggren called and we had a showdown. 

Casabona:
Berggren:

The turn came and river which doubled the Italian's stack to 70,000.

Player Chips Progress
Massimo Casabona 70,000 29,000
Christopher Berggren 55,000 5,000
20:19 (UTC+0)
Start of Level 7
Blinds: 500/1,000     Ante: 1,000
Midnight Madness! Posted Thursday 21st September, 2023 at 20:04(UTC+0) by Jason Glatzer

WSOP Circuit Tallinn Tournament Director Teresa Nousiainen announced to the Main Event crowd a Midnight Madness mega satellite.

The €150 buy-in event, which guarantees 15 Main Event seats valued at €1,500 each, was just added to the schedule for tonight at midnight.

The 15 (or more) players that win a seat will join others for tomorrow's Day 2 when late registration will close before the start of the third blind level of the day.

Best of luck to all satellite players!

19:49 (UTC+0)
Start of Level 6
Blinds: 400/800     Ante: 800
Two WSOP Bracelet Winners in the Field Posted Thursday 21st September, 2023 at 19:48(UTC+0) by Lina Olofsson

As day 1D is on it's fifth level we've spotted two familiar faces in the tournament floor. Estonian Ranno Sootla and Vincas Tamasauskas are both former WSOP bracelet winners on the hunt for a ring to match with it in the €1,500 Main Event. 

Player Chips Progress
Vincas Tamasauskas 50,000 0
Ranno Sootla 50,000 0
Another Bullet for Tool Posted Thursday 21st September, 2023 at 19:33(UTC+0) by Lina Olofsson

You can't accuse Steven Tool for not being eager to build his stack in this tournament as he just fired his fourth bullet in the Main Event when entering the day 1D flight here a couple of hours ago. He sit's with an healthy 90,000 in front of him and fingers crossed this bullet will be more successful than the first three for our Estonian player. 

Player Chips Progress
Steven Tool 90,000 40,000
First Break! Posted Thursday 21st September, 2023 at 19:30(UTC+0) by Lina Olofsson

91 players decided to jump into this last starting day so far. This is the last of the four starting flights in the €1,500 Main Event and will be a turbo in comparison to the first three starting days. 

After the first break of the day we have a few notable stacks in the field with Martin Koppl and Jari-Pekka Juhola as spotted with more than double the starting stack of 50,000 with 110,000 each. Below you'll find some other notable stacks. 

Player Chips Progress
Jari-Pekka Juhola 110,000 60,000
Martin Koppel 110,000 60,000
Massimo Casabona 99,000 49,000
Kristian Kostiander 95,000 45,000
Robert Berg 87,000 37,000
Juhana Konttinen 77,000 27,000
Luka Sorainen 70,000 20,000
Kristopher Kuusk 65,500 15,500
Eedi Kirves 65,000 15,000
Welcome to Day 1D - Final Flight Of The Main Event Posted Thursday 21st September, 2023 at 18:02(UTC+0) by Alaxandar Georgiev

The action continues at full speed with the last flight of the 2023 WSOPC Tallinn €1,500 Main Event which started at 19:00 and already has more than 70 players registered. This is the player's last chance to enter Day 2 of the main event where the prize pool is  €1 million guaranteed.

The flight starts with 50,000 chips for each player, but this one has the blinds increase every 30 minutes. The chips will be flying and players will battle it down for the last seats into Day 2.

We begin coverage for this event at 21:15 at level 5 with blinds at 300/600 and a 600 big blind ante, since the last flight overlaps with Main Event Day 1C.

17:45 (UTC+0)
Day 1D of WSOPC Tallinn Started
Level: 5     Blinds: 300/600     Ante: 600

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.