0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0062 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-12-27'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/93'
ORDER BY `views` DESC

0.0007 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/93', 1, '2024-12-27')

0.0003 SECONDS: 
SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, 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.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 `tour_stop_blogs`.`id` = '93'

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

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

0.0065 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.0057 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.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11764'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11752'
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` = '11751'
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` = '11750'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11746'
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` = '11744'
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` = '11739'
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` = '11732'
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` = '11731'
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` = '11724'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11723'
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` = '11717'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11710'
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` = '11708'
ORDER BY `chip_change` DESC, `busted` ASC

0.0065 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11697'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11693'
ORDER BY `chip_change` DESC, `busted` ASC

0.0067 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.0083 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.0066 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11678'
ORDER BY `chip_change` DESC, `busted` ASC

0.0070 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.0065 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11672'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11664'
ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11661'
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` = '11641'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0057 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.0067 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.0068 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11752'
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` = '11751'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11750'
ORDER BY `chip_change` DESC, `busted` ASC

0.0065 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11746'
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` = '11744'
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` = '11739'
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` = '11732'
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` = '11731'
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` = '11724'
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` = '11723'
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` = '11717'
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` = '11710'
ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11708'
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` = '11697'
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` = '11693'
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` = '11690'
ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11684'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11678'
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` = '11674'
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` = '11672'
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` = '11664'
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` = '11661'
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` = '11641'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

    

Open Modal

Hi,

We'd like to send you push notifications so you never miss out on:

• Exclusive Offers
• Upcoming Events
• Exciting Promotions
• Poker Travel News

Don’t worry; we won’t bombard you with messages, and you can-opt out anytime by logging into your account and changing your settings.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

Translate

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

Kings of Tallinn 2024 Event #49: €3,000 NLH (English) Live Reporting - Day 2

Kings of Tallinn 2024 - Live Reporting

Event #49: €3,000 NLH (English) See other events

Event #12: €555 Championship (English) Event #29: €1,100 Main Event (English) Event #42: €5,000 High Roller (English) Event #49: €3,000 NLH (English) Event #3: €350 Kings of Tallinn Cup (Estonian) Event #12: €555 Championship (Estonian) Event #27: €150 Celebrity Event (Estonian) Event #29: €1,100 Main Event (Estonian) Event #42: €5,000 High Roller (Estonian) Event #49: €3,000 NLH (Estonian) Event #12: €555 Championship (Finnish) Event #29: €1,100 Main Event (Finnish) High Roller Events (Finnish)

Kings of Tallinn 2024 - Live Reporting Event #12: €555 Championship (English) Event #29: €1,100 Main Event (English) Event #42: €5,000 High Roller (English) Event #49: €3,000 NLH (English) Event #3: €350 Kings of Tallinn Cup (Estonian) Event #12: €555 Championship (Estonian) Event #27: €150 Celebrity Event (Estonian) Event #29: €1,100 Main Event (Estonian) Event #42: €5,000 High Roller (Estonian) Event #49: €3,000 NLH (Estonian) Event #12: €555 Championship (Finnish) Event #29: €1,100 Main Event (Finnish) High Roller Events (Finnish)

---

Current Level 24 Current Day 2

---

Blinds 25,000/50,000 Ante 50,000

Entries 58 Remaining 1

---

Prize Pool (EUR) €154,280 First Prize (EUR) €52,430

Chip Leaders Day 2

1

Georgios Tsouloftas

2,900,000

Day 2

Live Updates Chip Counts Structure Gallery Payouts

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