0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0065 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-12-04'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/91/245/updates'
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/91/245/updates', 1, '2024-12-04')

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` = '91'

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

0.0280 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0060 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '241'
AND `published` = 1

0.0272 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0052 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '245'
AND `published` = 1

0.0271 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0050 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '250'
AND `published` = 1

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

0.0276 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0052 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '256'
AND `published` = 1

0.0272 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0048 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '263'
AND `published` = 1

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

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

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` = '10912'
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` = '10911'
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` = '10887'
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` = '10882'
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` = '10879'
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` = '10877'
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` = '10873'
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` = '10872'
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` = '10871'
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` = '10869'
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` = '10864'
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` = '10863'
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` = '10857'
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` = '10858'
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` = '10851'
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` = '10850'
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` = '10847'
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` = '10844'
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` = '10838'
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` = '10837'
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` = '10833'
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` = '10830'
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` = '10828'
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` = '10827'
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` = '10825'
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` = '10821'
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` = '10819'
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` = '10816'
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` = '10815'
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` = '10810'
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` = '10806'
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` = '10803'
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` = '10801'
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` = '10798'
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` = '10795'
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` = '10790'
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` = '10788'
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` = '10786'
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` = '10781'
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` = '10780'
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` = '10778'
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` = '10772'
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` = '10770'
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` = '10765'
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` = '10764'
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` = '10761'
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` = '10756'
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` = '10753'
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` = '10750'
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` = '10748'
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` = '10747'
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` = '10745'
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` = '241'
ORDER BY `busted` ASC, `current_chips` DESC

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

0.0053 SECONDS: 
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '245'
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` = '10912'
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` = '10911'
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` = '10887'
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` = '10882'
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` = '10879'
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` = '10877'
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` = '10873'
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` = '10872'
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` = '10871'
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` = '10869'
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` = '10864'
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` = '10863'
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` = '10857'
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` = '10858'
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` = '10851'
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` = '10850'
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` = '10847'
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` = '10844'
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` = '10838'
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` = '10837'
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` = '10833'
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` = '10830'
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` = '10828'
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` = '10827'
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` = '10825'
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` = '10821'
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` = '10819'
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` = '10816'
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` = '10815'
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` = '10810'
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` = '10806'
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` = '10803'
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` = '10801'
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` = '10798'
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` = '10795'
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` = '10790'
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` = '10788'
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` = '10786'
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` = '10781'
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` = '10780'
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` = '10778'
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` = '10772'
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` = '10770'
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` = '10765'
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` = '10764'
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` = '10761'
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` = '10756'
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` = '10753'
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` = '10750'
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` = '10748'
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` = '10747'
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` = '10745'
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` = '245'
ORDER BY `busted` ASC, `current_chips` DESC

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

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

0.0058 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '263'
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 #29: €1,100 Main Event (English) Live Reporting - Day 4

Kings of Tallinn 2024 - Live Reporting

Event #29: €1,100 Main Event (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 35 Current Day 4

---

Blinds 200,000/400,000 Ante 400,000

Entries 914 Remaining 1

---

Prize Pool (EUR) €859,160 First Prize (EUR) €120,910

Chip Leaders Day 4

1

Edgaras Kausinis

27,000,000

Day 1a Day 1b Day 1c Day 2 Day 3 Day 4

Live Updates Chip Counts Structure Gallery Payouts

1 New Update - Click to refresh

Live Updates - Day 1b

20:55 (UTC+0)

Day 1b of Kings of Tallinn 2024 Ended
Level: 8     Blinds: 500/1,000     Ante: 1,000

2024 Kings of Tallinn €350 Cup Champion Sven Omland Bags Day 1b Chip Lead Posted Thursday 29th February, 2024 at 20:54(UTC+0) by Jason Glatzer

The 2024 Kings of Tallinn €1,100 Main Event has already more than lived up to its billing and will be easily the largest in the festival's 10-year history. The €500,000 guarantee was smashed less than midway through the day with nearly €600,000 in the prize pool with still tonight's Day 1c and four levels of late registration on tomorrow's Day 2 not yet factored in.

Day 1b attracted 385 entries to bring the total number of entries up to 623 entries when taking into account the 238 entries on Wednesday's Day 1a. Remarkably, already 254 players have punched their tickets including 167 players on Day 1b into Day 2.

Earlier this week, Sven Omland shipped the two-day Kings of Tallinn €350 Cup for €19,200. Today he shined the brightest again amongst the massive field and bagged the Day 1b chip lead with 233,800.

This still places him far behind the more than 300,000 bagged on Day 1a by Christian "Sleeping Beauty" Rysgaard. You can read more about that by clicking on "Day 1a" in our coverage.

Omland wasn't the only one who advanced with a big stack on Day 1b as Latvia's Adrian Imsa (205,600), Spain's Josep Pastor (196,400), Finland's Henri Wagner (193,500), and local hero Ramel Kasi (180,500) all were picking up pots from the opening bell and dominating throughout the day to end in the top five on the leaderboard.

You can check out the full chip counts by clicking on the "Chip Counts" tab in our coverage. We will be back to report the final chip counts of Day 1c and link you to the seat draw for Day 2 before the night is over.

Players Bagging Chips Posted Thursday 29th February, 2024 at 18:45(UTC+0) by Jason Glatzer

Players are bagging their chips into tomorrow's Day 2. We will update the final chip counts of the day in about an hour.

Meanwhile, Day 1c kicks off at 9 p.m. We will not be covering that flight but will provide the final chip counts and the seat draw for tomorrow's Day 2 upon its conclusion. If you believe the 2023 Kings of Tallinn Summer Showdown Main Event runner-up Phil Gross (pictured below), it is going to be huge as he shared that he believes there will be more than 225 entries in the final opening flight alone and was willing to put a drink bet behind that statement.

Players can get into the action even after Day 1c as late registration will remain open during the first four blind levels of tomorrow's Day 2.

Pastor Flushes Daunaravicius to the Rail Posted Thursday 29th February, 2024 at 18:28(UTC+0) by Jason Glatzer

Level 8: 500/1,000 (1,000)
Entries: 186/385

The action paused on Josep Pastor for a few minutes with about 45,000 in the pot and the on the board before he effectively jammed betting 50,000.

Vaidas Daunaravicius paused for a few moments before he called off his stack of around 20,000. Pastor had the nuts with with a timely river to send Daunaravicius to the rail near the end of Day 1b after he turned over the for an overpair to the board.

Player		Chips	Progress
Josep Pastor		170,000	50,000
Vaidas Daunaravicius		0	0

Friends Collide Posted Thursday 29th February, 2024 at 18:18(UTC+0) by Jason Glatzer

Level 8: 500/1,000 (1,000)
Entries: 186/385

As we mentioned earlier today, Kaisa Soursa traveled with her friend and Kings of Tallinn veteran Anne Bezdek (pictured below) from Finland to enjoy an extended week of poker action and good company at Olympic Park Casino.

They were sitting side-by-side on Table 21 and just noticed that Bezdek was not in her seat. Antti Perttula, who was also at the table, confirmed that Bezdek lost her stack and didn't simply move tables.

We learned a little later, that it was Soursa who was responsible for bringing a little friend vs. friend crime into the mix.

Perttula shared that Bezdek jammed for 14 big blinds from under the gun with king-nine. Soursa, who was one seat over, isolated with aces. The board ran dry for Bezdek and she will likely take comfort that it is travel buddy who has her chips instead of someone that she doesn't know.

Player		Chips	Progress
Antti Perttula		96,000	51,000
Kaisa Soursa		95,000	10,000
Anne Bezdek		0	0

Cipollini Folds Trip Ducks Facing Leinonen's Jam Posted Thursday 29th February, 2024 at 18:10(UTC+0) by Jason Glatzer

Level 8: 500/1,000 (1,000)
Entries: 193/384

Federico Cipollini bet 11,500 from the big blind into a pot north of 25,000 with the on the board. Santtu Leinonen (pictured below) jammed for 38,800 and Cipollini tanked for about five minutes.

Cipollini separated out the chips he would have needed to call and was trying to ask Leinonen questions. Leinonen stayed stoically quiet and stared down at the table the entire time.

Eventually, Rolf Jauring called for time. The floor came over and consulted with the dealer who confirmed that Cipollini had plenty of time before the clock was called.

Cipollini opted to fold as the clock hit 1 second. He flashed first to his neighbor and then to the entire table that he made a big fold with thinking his trip ducks weren't good enough.

Leinonen opted not to show his hand, so we will never know if it was a good results-oriented fold or not.

Player		Chips	Progress
Santtu Leinonen		80,000	50,000
Federico Cipollini		57,000	18,000

Final Blind Level of Day 1b Posted Thursday 29th February, 2024 at 17:47(UTC+0) by Jason Glatzer

Level 8: 500/1,000 (1,000)
Entries: 200/383

The final blind level of Day 1b has kicked off. The clock will stop near the end of the blind level when the tournament staff will randomly select the number of hands each table will need to play before the surviving players can bag their chips into tomorrow's Day 2.

Meanwhile, Day 1c will kick off in about an hour at 9 p.m. with a faster 30-minute blind structure. While we will not provide full reporting for this opening flight, we do promise to update the final statistics, chip counts, and also share a seat draw for tomorrow's Day 2.

17:44 (UTC+0)

Start of Level 8
Blinds: 500/1,000     Ante: 1,000

Ojaveer Having Fun Posted Thursday 29th February, 2024 at 17:41(UTC+0) by Jason Glatzer

Level 7: 400/800 (800)
Entries: 202/382

Poker streamer Oskar Ojaveer, also known as Deckflow, was recently moved to Table 1 not too far away from Paul Koppe.

"I am having fun," Ojaveer said when we asked him about his day. 

There weren't any huge hands but Ojaveer mentioned that he may have gotten under the skin of Estonian poker legend Mauri Dorbek when he called him down on the river in a three-bet pot with just ace-high. 

Ojaveer is near an average stack with 46,500 and we wish him the best of luck on his journey in the 2024 Kings of Tallinn Main Event.

Player		Chips	Progress
Oskar Ojaveer		46,500	16,500

"Show One, Show All" Posted Thursday 29th February, 2024 at 17:34(UTC+0) by Jason Glatzer

Level 7: 400/800 (800)
Entries: 204/382

Dawid Zielinski bet 10,000 or less with two 5,000-denominated chips in front of him into a pot of around 12,000 with the already dealt on the flop.

Justas Semaska (pictured below) tanked for more than a minute before he jammed for 19,200. Zielinski was busy getting a massage and asked for a count. His massage continued but his decision was still forthcoming. About a minute later he asked how much the bet was again.

"Too much," Zielinski said before folding his hand.

Semaska breathed a huge sigh of relief and showed a player on the rail his cards.

"Show one, show all," said the dealer.

Semaska then turned over his cards to show he made a move with the bottom pair along with a gutshot Broadway and backdoor flush draw with .

Player		Chips	Progress
Dawid Zielinski		85,000	15,900
Justas Semaska		40,000	10,000

Talviste Drawing Dead to Zahl Posted Thursday 29th February, 2024 at 17:11(UTC+0) by Jason Glatzer

Level 7: 400/800 (800)
Entries: 212/380

Peer Zahl bet 6,500 into a pot of a bit more with the on the board after the turn. Peeter Talviste jammed for around 25,000. Zahl snap-called and had Talviste drawing dead to his straight.

Peeter Talviste:
Peer Zahl:

Talviste's chips officially went into Zahl's stack after the river completed the board.

Player		Chips	Progress
Peer Zahl		60,000	30,000
Peeter Talviste		0	0

Ponnio Runs Into Tori's Broadway Posted Thursday 29th February, 2024 at 17:03(UTC+0) by Jason Glatzer

Level 7: 400/800 (800)
Entries: 219/379

Risto Ponnio had his stack of 18,000 committed from the button and was up against WSOPC Tallinn €1,500 Main Event fifth-place finisher Mairo Tori, who already piled up some chips before the last break.

Risto Ponnio:
Mairo Tori:

Ponnio was ahead after the flop but was already out of the chair. The turn wasn't even fully on the board as Ponnio turned over his hand understanding he was drawing dead.

"I knew it was coming," Ponnio said with a small smile.

The river made the hand official and Ponnio, who is well known for his OFC and mixed game prowess, will need to re-enter if he wants a shot at snagging a piece of what will be a record-breaking Kings of Tallinn prize pool.

Player		Chips	Progress
Mairo Tori		155,000	50,000
Risto Ponnio		0	0

Kasi Over 200K at Break Posted Thursday 29th February, 2024 at 16:44(UTC+0) by Jason Glatzer

Level 7: 400/800 (800)
Entries: 218/376

Estonia's Ranel Kasi held the chip lead at the break and already surpassed 200,000 in chips from his 30,000 opening stack.

Check out some of the bigger stacks from around the room below:

Player		Chips	Progress
Ranel Kasi		225,600	120,600
Sven Omland		164,000	72,000
Henri Wagner		140,000	42,000
Jani Tuovinen		135,000	70,000
Ignacio Garrido		120,800	29,800
Margus Tuvikene		120,000	90,000
Josep Pastor		120,000	90,000
Sauli Haapaniemi		117,000	87,000
Jari-Pekka Juhola		117,000	87,000
Tomi Arponen		111,300	81,300
Mairo Tori		105,000	75,000

16:43 (UTC+0)

Start of Level 7
Blinds: 400/800     Ante: 800

Final Break Posted Thursday 29th February, 2024 at 16:24(UTC+0) by Jason Glatzer

Players are about to head on their final break of Day 1b. Blinds will increase to 400/800 (800) and 500/1,000 (1,000) before surviving players bag and tag their chips into tomorrow's Day 2.

We will update the bigger stacks from around the room shortly after the break.

Friends Bezdek and Soursa Sitting Side-By-Side Posted Thursday 29th February, 2024 at 16:21(UTC+0) by Jason Glatzer

Level 6: 300/600 (600)
Entries: 229/371

Anne Bezdek has been part of the Kings of Tallinn fabric since the beginning of the event in 2015. She traveled to Estonia with her close friend Kaisa Soursa, and as fate would have it the two players are sitting side by side at Table 21.

Both players are above a starting stack but Soursa's stack is nearly a triple starting stack. It could have been more as she doubled up Antti Perttula when her king-queen didn't get there against ace-king.

"I remember there were two fives on the board," Bezdek said with a friendly smile. "And I had ten-five."

Meanwhile, Perttula took a bad beat shortly after we witnessed the fun table dynamic between two friends. Romet Martjan got his last 10,200 in the middle with king-ten and nailed a king on the flop to double up with Perttula's pocket queens missing the cut.

Anne Bezdek appeared as a guest in the inaugural episode of the OlyBet Poker Podcast chatting with Jason Glatzer, Teresa Nousiainen, and Kelly Limonova about the Kings of Tallinn and more. Check out the episode below:

Player		Chips	Progress
Kasia Soursa		85,000	55,000
Antti Perttula		45,000	15,000
Anne Bezdek		35,000	5,000
Romet Martjan		22,000	8,000

Ziigmund in the House Posted Thursday 29th February, 2024 at 16:06(UTC+0) by Jason Glatzer

Level 6: 300/600 (600)
Entries: 234/369

Finnish online poker legend Ilari "Ziigmund" Sahamies (pictured below) is a staple here in Tallinn having attended many of the bigger festivals over the years. He is busy getting a massage and trying to build a stack.

To Ziigmund's left is the charismatic Estonian Andrey Koks and to his right is last night's eighth-place finisher in the €555 Championship Matte Karjalainen creating an interesting trio sitting side by side.

Karjalainen recently won a small pot to get back above a starting stack, while Koks is still above a starting stack as well.

Best of luck to all three players.

Player		Chips	Progress
Andrey Koks		50,000	20,000
Matte Karjalainen		35,000	5,000
Ilari Sahamies		33,000	3,000

PLO Mystery Bounty Champ Koppe With the Magical Seat (and a Full House) Posted Thursday 29th February, 2024 at 15:47(UTC+0) by Jason Glatzer

Level 6: 300/600 (600)
Entries: 239/353

Magic flew through the air earlier this week when Paul Koppe (pictured below) defeated Janne Nevalainen heads-up in the €555 PLO Mystery Bounty after flopping a rare Royal Flush. Koppe then proceeded to take down the largest mystery bounty from the event and more.

Now, Koppe has the magical chair as he is seated in Seat 1 at Table 1 and has used that magic his poker acumen to chip up nicely on Day 1b. We learned that he picked up a big stack in a spot that would have awarded a bad beat jackpot downstairs in the casino in the cash games when his ace-king beat pocket kings with two aces and a king on the board.

In a more recent hand, Koppe fired out for 15,000 with the  on the board. Jesper Hansen went into the tank for about two minutes before he called.

Hansen mucked his hand after Koppe turned over the for a full house, however, he told the table later when they asked that he had ace-king.

Player		Chips	Progress
Paul Koppe		120,000	90,000
Jesper Hansen		15,000	15,000

15:33 (UTC+0)

Start of Level 6
Blinds: 300/600     Ante: 600

Baixas Unable to Get Past King-Deuce Three-Bet Special by Kauppi Posted Thursday 29th February, 2024 at 15:33(UTC+0) by Jason Glatzer

Level 5: 200/500 (500)
Entries: 239/353

Jordi Baixas (pictured below) took fifth place last night in the €555 Championship out of a record-breaking 700 entries to bank €15,200. He now hopes for even better success in the €1,100 Main Event. He may not have won the following pot, but is in general heading in the right direction.

Baixas opened for 1,200 from the button and was called by Mykolas Guiga. Juuso Kauppi three-bet to 5,500 from the big blind. Baixas called and Guiga got out of the way.

The board was checked the entire way. Kauppi turned over the and his connecting king on the river was good enough as Baixas opted to muck his hand.

Player		Chips	Progress
Mykolas Guiga		65,000	6,000
Jordi Baixas		50,000	20,000
Juuso Kauppi		45,000	15,000

Byrne Picks Up a Small Pot Off Piik Posted Thursday 29th February, 2024 at 15:24(UTC+0) by Jason Glatzer

Level 5: 200/500 (500)
Entries: 239/349

It wasn't a big hand that was important to report but it involved two notable people in FLIP founder and Queens of Tallinn host Daiva Byrne and former OlyBet Poker Manager Martin Piik with Byrne.

Don't think just because they helped grow poker that they don't know how to play as both are known as strong poker players.

Byrne, who hasn't been witnessed above a starting stack the entire day, changed that by winning a small pot off Piik. 

Piik picked up some chips before this and is well north of a starting stack.

Best of luck to both players in finding a big bag into Friday's Day 2.

Player		Chips	Progress
Martin Piik		50,000	20,000
Daiva Byrne		32,000	2,000

Maisins Doubles With Top Pair Posted Thursday 29th February, 2024 at 15:05(UTC+0) by Jason Glatzer

Level 5: 200/500 (500)
Entries: 246/342

There was already more than 20,000 in the pot with the on the flop when Gatis Maisins (pictured below) had his 26,600 stack committed against Jani Tuovinen.

Gatis Maisins:
Jani Tuovinen:

"There we go," Tuovinen said about the turn as it opened up a few more outs with a gutshot straight draw. 

However, Tuovinen paid off Maisins after the blank river completed the board.

Player		Chips	Progress
Gatis Maisins		75,000	45,000
Jani Tuovinen		65,000	37,000

Day 6 Video Highlights Posted Thursday 29th February, 2024 at 14:59(UTC+0) by Jason Glatzer

Check out the video highlights from Day 6 of the 2024 Kings of Tallinn:

Event #36: €250 NLH Kicking Off Posted Thursday 29th February, 2024 at 14:57(UTC+0) by Jason Glatzer

The one-day Event #36: €250 NLH is about to begin. The tournament offers plenty of action with a starting stack of 20,000 and 20-minute blind levels.

Late registration will be open until approximately 8:15 p.m. when Level 10 begins.

Vygerdas Jonikas, WSOP Circuit Tallinn Opening Event champion Viacheslav Sultanov, and Georgios Tsouloftas (pictured below) are among the players already registered for the action.

Kasi Barrels River Posted Thursday 29th February, 2024 at 14:50(UTC+0) by Jason Glatzer

Level 5: 200/500 (500)
Entries: 250/322

Estonia's Ranel Kasi had 78,000 on the break and has chipped up beyond 100,000 in the following hand.

Albert Martinez Domenech opened for 1,000 from the cutoff. Kasi three-bet to 3,000 from the big blind and Domenech called.

Kasi continued for 2,800 on the flop and for 8,000 on the turn. Domenech called both times to see the river. Kasi bet 40,000 for more than his opponent had in his stack. Domenech tanked for more than a minute before he folded.

Player		Chips	Progress
Ranel Kasi		105,000	75,000
Albert Martinez Domenech		20,000	10,000

Beretta Leads at Break Posted Thursday 29th February, 2024 at 14:35(UTC+0) by Jason Glatzer

Level 5: 200/500 (500)
Entries: 250/322

2020 Kings of Tallinn Summer Showdown Main Event runner-up from Italy Luca Beretta led the way at the break. Check out some of the top stacks from around the room.

Player		Chips	Progress
Luca Beretta		108,000	78,000
Maher Mahmoud		105,000	75,000
Jani Tuovinen		102,000	72,000
Sascha Manns		99,500	34,500
Henri Wagner		98,000	8,000
Svein Mathiassen		92,000	62,000
Sven Omland		92,000	62,000
Ignacio Garrido		91,000	27,000
Tomas Pinkevicius		85,000	55,000
Oleksii Lubnin		83,200	53,200
Robertas Smolskis		83,000	53,000

14:31 (UTC+0)

Start of Level 5
Blinds: 200/500     Ante: 500

Break Time! Posted Thursday 29th February, 2024 at 14:11(UTC+0) by Jason Glatzer

Players are about to embark on their second break of Day 1b. Blinds will increase to 200/500 (500) and 300/600 (600) before the final break of the day in a little more than two hours.

We will update some of the biggest stacks from around the room shortly after the break.

Modens Doubles Through Garcia Posted Thursday 29th February, 2024 at 14:06(UTC+0) by Jason Glatzer

Level 4: 200/400 (400)
Entries: 232/317

Mindaugas Bertulis opened for 1,000 from middle position and was called by Davis Modens from the hijack and Kristian Kostiander from the cutoff.  Miki Garcia three-bet to 4,200 from the small blind and only got one call by Modens.

Garcia fired out for 2,000 on the flop. Modens jammed for 11,600 and Garcia snap-called.

Davis Modens:
Miki Garcia:

Modens had a draw and eventually won the hand with two pair after the turn and river completed the board to double his stack.

Player		Chips	Progress
Miki Garcia		40,000	10,000
Davis Modens		35,000	5,000

"Let's See" (Or Not) Posted Thursday 29th February, 2024 at 13:43(UTC+0) by Jason Glatzer

Level 4: 200/400 (400)
Entries: 253/309

Sergejs Kacapovs checked the river with the on the board before Juri Vassin fired out for 7,500 into a pot of around 24,000.

Kacapovs tanked silently for about a minute before he spoke up.

"Let's see," Kacapovs said to Vassin before tossing in a chip to call.

Although Kacapovs paid the price, he wasn't able to see as Vassin snap-mucked his cards. Kacapovs is likely not complaining about the outcome as he won the pot regardless of seeing Vassin's cards or not.

Player		Chips	Progress
Sergejs Kacapovs		50,000	20,000
Juri Vassin		24,000	6,000

€500K Guarantee Dusted Off! Posted Thursday 29th February, 2024 at 13:25(UTC+0) by Jason Glatzer

Level 4: 200/400 (400)
Entries: 250/295

A couple of more players got into the mix to increase the Day 1b field size to 295 entries. This combined with the 238 entries from Day 1a brings 535 entries already to already dust off the €500,000 guarantee.

Now it is just a matter of how big the 2024 Kings of Tallinn €1,100 Main Event will grow to. The sky appears to be the limit based on what we have witnessed thus far.

€500K Guarantee Nearly Met Posted Thursday 29th February, 2024 at 13:22(UTC+0) by Jason Glatzer

Level 4: 200/400 (400)
Entries: 248/293

The Main Event is only two players away from surpassing the lofty €500,000 guarantee during the opening moments of Level 4 on Day 1b.

13:18 (UTC+0)

Start of Level 4
Blinds: 200/400     Ante: 400

Fors Runs Into Karim's Straight Posted Thursday 29th February, 2024 at 13:03(UTC+0) by Jason Glatzer

Level 3: 100/300 (300)
Entries: 243/280

Jonatan Fors (pictured below) paused for several moments before jamming for more than the 19,400 Michel Karim had in his stack before he opted to jam into a pot of around the same with the on the board.

Karim snap-called. Fors turned over the for top pair and top kicker. However, this wasn't enough as Karim had the nuts with for a straight.

Player		Chips	Progress
Michel Karim		60,000	30,000
Jonatan Fors		28,000	2,000

"Always Trouble With Queens" Posted Thursday 29th February, 2024 at 12:47(UTC+0) by Jason Glatzer

Level 3: 100/300 (300)
Entries: 242/269

Henri Wagner (pictured below) already chipped up after ousting Hanna Heinlo after his set of fours cracked aces. He just added some more chips as follows:

Wagner from the big blind bet 5,000 into a pot of around double that with the  on the board. Pekka Virtanen quickly called from the button and the river completed the board.

Wagner fired out for 11,500. Virtanen tanked for more than a minute before he opted to call. Wagner tabled the and won the hand with and overpair to the board after Virtanen mucked. At this point, Wagner let out a huge sigh of relief.

"Always trouble with queens," Adomas Juozapavicius, who was also at the table, said to Wagner.

Wagner nodded in agreement as he began to stack up his chips.

Player		Chips	Progress
Henri Wagner		90,000	60,000
Pekka Virtanen		14,000	16,000

Various Big Stacks at Break Posted Thursday 29th February, 2024 at 12:30(UTC+0) by Jason Glatzer

The 2023 World Series of Poker Circuit Main Event Champion Ignacio Garrido (pictured below celebrating with friends) is looking to win another Main Event.

The Spanish player living in Estonia was in the top five of the leaderboard at the break. Check out some of the bigger stacks from around the room.

Player		Chips	Progress
Adrians Imsa		80,000	15,000
Mykolas Guiga		71,000	41,000
Dawid Zielinski		69,100	39,100
Frederik Brink		67,300	37,300
Ignacio Garrido		64,000	34,000
Daniyel Destici		63,800	33,800
Laur Sibold		63,000	33,000
Arto Lehtonen		62,400	22,400

Day 1b Bigger Than Day 1a Posted Thursday 29th February, 2024 at 12:25(UTC+0) by Jason Glatzer

Level 3: 100/300 (300)
Entries: 228/245

Several players hopped in on the break to grow Day 1b to 245 entries. This means Day 1b is officially bigger than the 238 entries attracted during Day 1a.

Unfortunately, Finnish poker legend Aki Pyysing (pictured below at the 2023 Kings of Tallinn Summer Showdown) is one of the players on the rail. He already quickly re-entered and we wish him the best of luck on his second Day 1b bullet.

Player		Chips	Progress
Aki Pyysing		30,000	0

12:18 (UTC+0)

Start of Level 3
Blinds: 100/300     Ante: 300

First Break Posted Thursday 29th February, 2024 at 12:00(UTC+0) by Jason Glatzer

Players are on their first 15-minute break. Blinds will increase to 100/300 with a 300 big blind ante before moving ahead to 200/400 with a 400 big blind ante before the second break takes place.

Queens of Tallinn Host Daiva Byrne in Action Posted Thursday 29th February, 2024 at 11:51(UTC+0) by Jason Glatzer

Queens of Tallinn host and FLIP founder Daiva Byrne (pictured below) is in action and ready to rumble. Finnish poker journalist Aki Pyysing was also witnessed just entering.

Others noticed around the room include Paulius Jucys, Markku Koplimaa, Aleksandrs Krumins, and Mark Metsla.

Player		Chips	Progress
Mark Metsla		30,000	0
Aleksandrs Krumins		30,000	0
Markku Koplimaa		30,000	0
Paulius Jucys		30,000	0
Aki Pyysing		30,000	0
Daiva Byrne		30,000	0

Manns "Repaired Damage" While Napel "Punted Stack" Posted Thursday 29th February, 2024 at 11:47(UTC+0) by Jason Glatzer

Level 2: 100/200 (200)
Entries: 205/221

"I have repaired the damage," Sascha Manns said as we walked by and noticed him on about double a starting stack after being the first player eliminated and first to re-enter.

"How did you double?" we asked.

Both Manns and 2024 Kings of Tallinn Cup champion Tobias Napel (pictured below) had a quick laugh.

"I punted my stack," Napel said with a smile.

"We were laughing because the floor was called at the end of the hand," Manns added. "Napel didn't want to show his cards at showdown when there was an all-in and a call."

Manns and Napel shared a little bit about the hand after the laughter died down.

Manns opened with cowboys and was called by Napel to see the flop. Both players checked the turn before Napel four-bet shoved the river.

Manns called and turned over the . This is when the floor was called before Napel turned over his .

"I wanted to show the table what kind of fish he is," Manns said with a laugh about Napel.

Napel laughed as well and we wish both of these friendly and fun players the best of luck.

Player		Chips	Progress
Sascha Manns		65,000	35,000
Tobias Napel		8,000	22,000

200 Entries Before First Break Posted Thursday 29th February, 2024 at 11:25(UTC+0) by Jason Glatzer

Level 2: 100/200 (200)
Entries: 194/200

Day 1b has already attracted 200 entries before the first break with 194 players remaining. Kelly Limonova, who appeared as a guest in the debut of the OlyBet Poker Podcast, Luis Rodriguez Cruz, and Trond Aanestad were the latest three players on the rail. Cruz re-entered while the other two players have not at least as of yet returned to the Main Event action.

Player		Chips	Progress
Luis Rodriguez Cruz		30,000	0
Trond Aanestad		0	0
Kelly Limonova		0	0

Whose Jack Was Better? Posted Thursday 29th February, 2024 at 11:17(UTC+0) by Jason Glatzer

Level 2: 100/200 (200)
Entries: 182/185

Hendry Kullamae and Maciej Komorowski (pictured below at the 2023 WSOPC Tallinn) both checked the turn with the on the board. Javier Moya bet 5,500 into a pot of 8,000. Kullamae called and about a minute later Komorowski jammed for 16,700. Moya snap-folded and Kullamae went into the tank for about two minutes.

He looked down at his cards at least twice before he opted to fold. He flashed the representing at least top pair. Komorowski opted to also show one card and turned over the . Whether his other card was better than Kullamae's card will never be officially known.

Roman Jezov and Hans Erlandsson both hit the rail during the opening minutes of Day 2. Erlandsson re-entered, while Jezov is still on the rail.

Player		Chips	Progress
Maciej Komorowski		36,000	6,000
Hans Erlandsson		30,000	0
Javier Moya		30,000	0
Hendry Kullamae		25,000	5,000
Roman Jezov		0	0

11:01 (UTC+0)

Start of Level 2
Blinds: 100/200     Ante: 200

Manns Runs Into Imsa's Flush Posted Thursday 29th February, 2024 at 10:58(UTC+0) by Jason Glatzer

Level 1: 100/100 (100)
Entries: 159/160

It is always a pleasure to see Germany's Sascha Manns in Tallinn. Manns shared last night that other operators should pay attention to what happens in Estonia as it is the perfect combination of poker and fun.

Manns had a little less fun thus far in the Main Event and was the first player on the rail. He was also the first player to re-enter. We caught up to the table after we saw him standing up and he recapped the action as he was heading to re-enter.

It was a three-bet pot when Manns check-called a bet by Adrians Imsa (pictured below) on the flop. Manns check-raised the turn leaving just 9,000 back. That went in on the river and Imsa quickly called.

Manns had the nut flush draw on the turn and two pair on the river as he tabled the . However, this was no match to the turned flush by Imsa who had a big smile on his face after effectively doubling through Manns with .

Player		Chips	Progress
Adrians Imsa		65,000	35,000
Sascha Manns		30,000	0

Cowboys Good for Lehtonen Posted Thursday 29th February, 2024 at 10:39(UTC+0) by Jason Glatzer

Level 1: 100/100 (100)
Entries: 138/138

Andre Al-Khabbaz check-called a bet of 3,000 by Arto Lehtonen into a pot of around 8,000 with the on the board after the turn before the river completed the board.

Al-Khabbaz checked again. Lehtonen tanked for about 20 seconds before he bet 6,000. Al-Khabbaz paused for about a minute before he called.

Lehtonen turned over the and his cowboys got the job done as Al-Khabbaz opted to muck his cards.

Meanwhile, Pasi Trollhjarta, had already chipped up at the same table with 45,000 in chips in his stack.

Player		Chips	Progress
Pasi Trollhjarta		45,000	15,000
Arto Lehtonen		40,000	10,000
Andre Al-Khabbaz		13,000	17,000

Century Mark Achieved Posted Thursday 29th February, 2024 at 10:21(UTC+0) by Jason Glatzer

Level 1: 100/100 (100)
Entries: 109/109

There are already more than 100 players in the Day 1b field early on Level 1. This will almost certainly more than double by the end of the day.

Leibgoren Chips Up With Better Full House Than Svendsen Posted Thursday 29th February, 2024 at 10:19(UTC+0) by Jason Glatzer

Level 1: 100/100 (100)
Entries: 99/99

Michel Leibgorin checked the board from the small blind before Kenneth Svendsen bet 800 from the button into a small pot. Leibgorin check-raised to 5,000. Svendsen paused for about 20 seconds before he called.

Leibgorin immediately tabled the for a full house. Svendsen flashed the representing a weaker full house before mucking the rest of his hand.

Player		Chips	Progress
Michel Leibgorin		37,000	7,000
Kenneth Svendsen		24,000	6,000

Early Players in Action Posted Thursday 29th February, 2024 at 10:06(UTC+0) by Jason Glatzer

Kings of Tallinn €555 Championship runner-up Andrius Bielskis (pictured below), Tomi Arponen, Hanna Heinlo, Monika Leek, Richard Melby, Davis Modens, and Tomas Pinkevicius are among the early players in action.

Player		Chips	Progress
Tomas Pinkevicius		30,000	0
Davis Modens		30,000	0
Richard Melby		30,000	0
Monika Leek		30,000	0
Hanna Heinlo		30,000	0
Tomi Arponen		30,000	0
Andrius Bielskis		30,000	0

Cards in the Air Posted Thursday 29th February, 2024 at 10:01(UTC+0) by Jason Glatzer

Level 1: 100/100 (100)
Entries: 80/80

Day 1b kicked off with 80 players registered. This will grow significantly as yesterday began with 50 players but eventually grew to 238 entries after the eight blind levels of one hour each were in the books.

10:00 (UTC+0)

Day 1b of Kings of Tallinn 2024 Started
Level: 1     Blinds: 100/100     Ante: 100

Welcome to Day 1b of the Main Event Posted Thursday 29th February, 2024 at 08:52(UTC+0) by Jason Glatzer

Welcome back to the live reporting coverage of the 2024 Kings of Tallinn €1,100 Main Event at Olympic Park Casino and the Hilton Tallinn Park. 

The €500,000 guarantee will likely be smashed today with yesterday witnessing a banner crowd of 238 entries. Today boasts the final two opening flights in Day 1b at 12 p.m. and Day 1c at 9 p.m. The field will grow even bigger after that with late registration open for the first four blind levels of Friday's Day 2.

Players start with a deep stack of 30,000 in chips good for 300 big blinds if playing from Level 1. Blinds increase slowly at one-hour each throughout the tournaments providing an amazing structure. The only exception to this is during tonight's Day 1c, which will boast 30-minute levels.

Opening flight players will battle for eight blind levels. Currently, Christian "Sleeping Beauty" Rysgaard remarkably catapulted his 30,000 opening stack into 304,300 during yesterday's Day 1a to sit on top of the leaderboard heading into Thursday.

Our coverage begins when cards are in the air for Day 1b at 12 p.m. While we won't be covering the turbo Day 1c, we do promise at the end of the day to provide chip counts and a Day 2 seat draw for tomorrow.