0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0051 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-30' AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_3000_NLH' ORDER BY `views` DESC

0.0009 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/2024_KOT_3000_NLH', 1, '2024-04-30')

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

0.0001 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'EUR'

0.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.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.0003 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

0.0002 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0001 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

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

0.0059 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` = '2024_KOT_3000_NLH'

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

0.0186 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0037 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '264' AND `published` = 1

0.0001 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `id` = '264'

0.0002 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '93' AND `name` = '2'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

English
Kings of Tallinn 2024 Event #49: €3,000 NLH (English) Live Reporting - Day 2
1 New Update - Click to refresh
Live Updates - Day 2
Georgios Tsouloftas Wins €3,000 NLH (€52,430); Ermo Kosk Eliminated in 2nd Place (€33,700) Posted Sunday 3rd March, 2024 at 16:00(UTC+2) by Jason Glatzer

Level 23: 25,000/50,000 (50,000)
Entries: 1/58

Georgios Tsouloftas opened for 150,000 from the button. Ermo Kosk three-bet shoved. Tsouloftas went into the tank before he asked for a count to confirm the jam was for 990,000. The Cypriot tanked another minute before he opted to call.

Ermo Kosk:
Georgios Tsouloftas:

Kosk fell behind instantly on the flop and fell one player shy of the title to Tsouloftas's two-pair after the turn and river completed the board.

Meanwhile, the Cypriot rail erupted and Tsouloftas and Kosk shook hands before the winner's photos were taken.

Congrats to Georgios Tsouloftas for shipping the €3,000 NLH for €52,430!

Player Chips Progress
Georgios Tsouloftas 2,900,000 735,000
Ermo Kosk 0 0
Updated Chip Counts Posted Sunday 3rd March, 2024 at 15:41(UTC+2) by Jason Glatzer
Player Chips Progress
Georgios Tsouloftas 2,165,000 365,000
Ermo Kosk 735,000 365,000
15:39 (UTC+2)
Start of Level 24
Blinds: 25,000/50,000     Ante: 50,000
No Deal for Kosk Posted Sunday 3rd March, 2024 at 15:39(UTC+2) by Jason Glatzer

A deal was briefly discussed before the action but Kosk wanted to play at least for a little while.

Luka Sorainen Eliminated in 3rd Place (€22,450) Posted Sunday 3rd March, 2024 at 15:33(UTC+2) by Jason Glatzer

Level 22: 20,000/40,000 (40,000)
Entries: 2/58

Luka Sorainen was down to about 3 big blinds when he jammed from the small blind. Georgios Tsouloftas snap-called from the big blind and it seemed like an amazing spot for Sorainen to double.

Luka Sorainen:
Georgios Tsouloftas:

Sorainen was flushed out in third place for €22,450 after the board improved Tsouloftas to a flush.

A small break took place as the heads-up action was being set up after the hand.

Player Chips Progress
Georgios Tsouloftas 1,800,000 565,000
Ermo Kosk 1,100,000 25,000
Luka Sorainen 0 0
Tsouloftas Takes the Lead Posted Sunday 3rd March, 2024 at 15:26(UTC+2) by Jason Glatzer

Level 22: 20,000/40,000 (40,000)
Entries: 3/58

The €3K NLH final table witnessed its first lead change with the torch being passed from Ermo Kosk to Georgios Tsouloftas after the following small hand.

Tsouloftas limped from the small blind before Ermo Kosk checked back his option from the big blind. Tsouloftas min-bet the flop. Kosk called and both players checked the turn. Tsouloftas bet 160,000 on the river.

Kosk folded which was good enough to give Tsouloftas the chip lead to the delight of the flag-waving Cypriot rail.

Player Chips Progress
Georgios Tsouloftas 1,235,000 5,000
Ermo Kosk 1,125,000 325,000
Luka Sorainen 340,000 10,000
Big Slick Does the Trick for Tsouloftas Posted Sunday 3rd March, 2024 at 15:11(UTC+2) by Jason Glatzer

Level 22: 20,000/40,000 (40,000)
Entries: 3/58

Luka Sorainen min-raised from the small blind. Georgios Tsouloftas, who has been active since the break in preflop action, three-bet jammed for 585,000 and Sorainen snap-called.

Georgios Tsouloftas:
Luka Sorainen:

The rail from Cyprus erupted after Tsouloftas doubled his stack with a better pair on the board.

"Let's go!" shouted Tsouloftas to his rail.

Player Chips Progress
Georgios Tsouloftas 1,130,000 665,000
Luka Sorainen 330,000 660,000
15:03 (UTC+2)
Start of Level 23
Blinds: 20,000/40,000     Ante: 40,000
Updated Chip Counts at Break Posted Sunday 3rd March, 2024 at 15:03(UTC+2) by Jason Glatzer
Player Chips Progress
Ermo Kosk 1,450,000 100,000
Luka Sorainen 990,000 210,000
Georgios Tsouloftas 465,000 165,000
Break Time! Posted Sunday 3rd March, 2024 at 14:43(UTC+2) by Jason Glatzer

Players are on their first break of the final table of the €3,000 NLH. Blinds will increase to 20,000/40,000 with a big blind ante when the action resumes in 15 minutes.

Sorainen Hero-Calls Tsouloftas With Ace-High Posted Sunday 3rd March, 2024 at 14:36(UTC+2) by Jason Glatzer

Level 21: 15,000/30,000 (30,000)
Entries: 3/58

It was a limped pot preflop when Luka Sorainen checked the river on the board. Georgios Tsouloftas tanked for a few minutes before he bet 220,000 into a pot of 300,000.

Sorainen paused for about a minute before he called. Tsouloftas turned over the and got his hand caught in the cookie jar with Sorainen making the hero call with to win the hand.

Player Chips Progress
Luka Sorainen 1,200,000 350,000
Georgios Tsouloftas 300,000 400,000
Updated Chip Counts Posted Sunday 3rd March, 2024 at 14:26(UTC+2) by Jason Glatzer
Player Chips Progress
Ermo Kosk 1,350,000 25,000
Luka Sorainen 850,000 225,000
Georgios Tsouloftas 700,000 250,000
14:19 (UTC+2)
Start of Level 22
Blinds: 15,000/30,000     Ante: 30,000
Jan-Mikael Kesanen Eliminated in 4th Place (€15,950) Posted Sunday 3rd March, 2024 at 14:19(UTC+2) by Jason Glatzer

Level 20: 10,000/25,000 (25,000)
Entries: 3/58

Luka Sorainen min-raised from under the gun before he called a three-bet shove by Jan-Mikael Kesanen to 295,000 from the big blind.

Jan-Mikael Kesanen:
Luka Sorainen:

Jacks held on the runout. The dealer then counted out both players stacks, and both had 295,000 for Kesanen to exit in fourth place for €15,950. Meanwhile, the top three players eached locked up at least a €22,450 payday.

Player Chips Progress
Luka Sorainen 625,000 285,000
Jan-Mikael Kesanen 0 0
Touko Berndtson Eliminated in 5th Place (€12,100) Posted Sunday 3rd March, 2024 at 14:06(UTC+2) by Jason Glatzer

Level 20: 10,000/25,000 (25,000)
Entries: 4/58

Georgios Tsouloftas opened for a min-raise from the cutoff. Touko Berndtson three-bet shoved from the button to 405,000. Tsouloftas quickly called with Berndtson at risk.

Touko Berndtson:
Georgios Tsouloftas:

Berndtson pulled out ahead on the flop but was drawing dead after Tousloftas nailed a set of cowboys on the turn. Berndtson was officially eliminated in fifth place for €12,100 after the river completed the board.

The final four players each locked up €15,950 at a minimum.

Player Chips Progress
Georgios Tsouloftas 950,000 200,000
Touko Berndtson 0 0
Premature Celebration by Kosk Posted Sunday 3rd March, 2024 at 13:57(UTC+2) by Jason Glatzer

Level 20: 10,000/25,000 (25,000)
Entries: 5/58

Touko Berndtson jammed the button for 380,000. Ermo Kosk asked for a count before he called from the big blind.

Touko Berndtson:
Ermo Kosk:

Berndtson pulled out ahead on the flop but Kosk celebrated after improving to Broadway on the turn.

Berndtson appeared disgusted at the turn of events and was out of his chair halfway ready to go to the cashier. Instead, the river put Broadway on the board for a chopped pot.

Player Chips Progress
Ermo Kosk 1,325,000 125,000
Touko Berndtson 405,000 115,000
13:48 (UTC+2)
Start of Level 21
Blinds: 10,000/25,000     Ante: 25,000
Viktor Chaikin Eliminated in 6th Place (€9,700) Posted Sunday 3rd March, 2024 at 13:39(UTC+2) by Jason Glatzer

Level 19: 10,000/20,000 (20,000)
Entries: 5/58

Vitkor Chaikin was down to crumbs but triple up to a little more than 100,000 when his big slick was good in the big blind against ace-seven. 

He got big slick again, but this time things played out differently. Luka Sorainen jammed for less than 10 big blinds from under the gun and Chaikin called from the small blind.

Viktor Chaikin:
Luka Sorainen:

Sorainen was ahead on the flop however, Chaikin pulled ahead on the turn. The river improved Sorainen to a wheel and the field was down to five players after Chaikin hit the rail in sixth place for €9,700.

Player Chips Progress
Luka Sorainen 340,000 105,000
Viktor Chaikin 0 0
Tsouloftas Doubles Through Kosk Posted Sunday 3rd March, 2024 at 13:27(UTC+2) by Jason Glatzer

Level 19: 10,000/20,000 (20,000)
Entries: 6/58

Georgios Tsouloftas doubled through chip leader Ermo Kosk after getting his short stack in on the flop.

Georgios Tsouloftas:
Ermo Kosk:

Tsouloftas had to fade some outs but let out a small celebration after Kosk bricked the turn and river to double his stack instead of hitting the rail.

Player Chips Progress
Ermo Kosk 1,200,000 220,000
Georgios Tsouloftas 750,000 425,000
13:24 (UTC+2)
Start of Level 20
Blinds: 10,000/20,000     Ante: 20,000
Pasi Sormunen Eliminated in 7th Place (€7,950) Posted Sunday 3rd March, 2024 at 13:23(UTC+2) by Jason Glatzer

Level 18: 10,000/15,000 (15,000)
Entries: 6/58

Pasi Sormunen seemingly came into the final table in a good spot. He was second in chips and had position on the chip leader Ermo Kosk.

However, the end result tells a different story as Sormunen just hit the rail in seventh place in the following cooler.

Kosk opened for 30,000 from under the gun. Sormunen three-bet to 80,000 from one seat over and Kosk called. Kosk check-called a bet of 75,000 by Sormunen on the flop before he checked again on the turn. Sormunen bet 145,000. Kosk raised to 400,000 and Sormunen tanked for a few minutes before he jammed for slightly more. Kosk snap-called and the hands were tabled.

Pasi Sormunen:
Ermo Kosk:

Sormunen was drawing to just two outs on the river to Kosk's flopped set of sevens. No miracle came on the river and Sormunen was the first on the rail.

Meanwhile, Kosk had a commanding lead on his five opponents after the hand.

Player Chips Progress
Ermo Kosk 1,420,000 495,000
Pasi Sormunen 0 0
Cards in the Air for the Final Table Posted Sunday 3rd March, 2024 at 13:07(UTC+2) by Jason Glatzer

Level 18: 10,000/15,000 (15,000)
Entries: 7/58

Cards are in the air for the final table of the €3,000 NLH. Best of luck to the final seven hopefuls.

13:05 (UTC+2)
Day 2 of Kings of Tallinn 2024 Started
Level: 19     Blinds: 10,000/15,000     Ante: 15,000
Ermo Kosk Leads €3K NLH Final Table Posted Sunday 3rd March, 2024 at 10:20(UTC+2) by Jason Glatzer

Estonia's Ermo Kosk is one of a few people to ever win a six-figure prize in a single event at the Kings of Tallinn. He achieved this milestone when he took runner-up to Sweden's Johan Karlsson in the 2020 Kings of Tallinn €1,100 Main Event with the assistance of a three-way deal at the final table.

Now, he has a chance to win his first-ever event at the Kings of Tallinn as he will start the final table of the two-day Event #49: €3,000 NLH among the seven players to advance to the final day.

Pasi Sormunen (770,000) isn't too far behind Kosk but after that there is a gap between this duo and the rest of the field with Georgios Tsouloftas (325,000), Touko Berndtson (290,000), Jan-Mikael Kesanen (260,000), Luka Sorainen (235,000), and Viktor Chaikin (95,000) taking their chances with their shorter stacks.

The €3,000 NLH attracted 58 entries, each starting with 50,000 in chips, to create a €154,280 prize pool. All seven final table players each locked up at least a min-cash of €7,950. However, all eyes are on the coveted trophy and the €52,430 top prize to the winner.

Cards will be in the air at 1 p.m. with blinds at 10,000/15,000 along with a 15,000 big blind ante and increasing every 30 minutes. We will report the biggest hands, bad beats, and more once cards are in the air. We will also be covering the final day of the Main Event, so hop back and forth to check out the coverage of both events.

Player Chips Progress
Ermo Kosk 925,000 0
Pasi Sormunen 770,000 0
Georgios Tsouloftas 325,000 0
Touko Berndtson 290,000 0
Jan-Mikael Kesanen 260,000 0
Luka Sorainen 235,000 0
Viktor Chaikin 95,000 0

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.