0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0074 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-23' AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/142/358/updates' ORDER BY `views` DESC

0.0008 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/142/358/updates', 1, '2024-11-23')

0.0004 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` = '142'

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

0.0272 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` = '345' AND `published` = 1

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

0.0270 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0055 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '354' AND `published` = 1

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

0.0270 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0056 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '356' AND `published` = 1

0.0273 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0056 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '357' AND `published` = 1

0.0293 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0064 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '358' AND `published` = 1

0.0270 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` = '364' AND `published` = 1

0.0270 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` = '372' AND `published` = 1

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

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

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

0.0078 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '15541' 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` = '15542' 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` = '15535' 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` = '15533' 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` = '15528' 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` = '15517' 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` = '15521' 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` = '15514' 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` = '15507' 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` = '15503' 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` = '15499' 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` = '15494' ORDER BY `chip_change` DESC, `busted` ASC

0.0168 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '15491' 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` = '15487' 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` = '15482' 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` = '15476' 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` = '15466' 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` = '15465' 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` = '15454' 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` = '15452' 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` = '15450' 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` = '15440' 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` = '15439' 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` = '15436' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0072 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '15426' 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` = '15428' 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` = '15422' 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` = '15421' 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` = '15415' 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` = '15413' 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` = '15410' 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` = '15407' 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` = '15405' 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` = '15402' 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` = '15398' 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` = '15395' ORDER BY `chip_change` DESC, `busted` ASC

0.0282 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '15393' 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` = '15385' 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` = '15383' 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` = '15384' 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` = '15379' 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` = '15375' 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` = '15373' 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` = '15371' 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` = '15367' 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` = '15364' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

0.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '15339' 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` = '15333' 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` = '15321' 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` = '15317' 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` = '15313' 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` = '15314' 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` = '15310' 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` = '15306' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '15302' 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` = '15299' 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` = '15298' 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` = '15293' 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` = '15207' 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` = '15208' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '345' 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` = '353' 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` = '357' ORDER BY `busted` ASC, `current_chips` DESC

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

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

0.0069 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '15541' 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` = '15542' 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` = '15535' 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` = '15533' 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` = '15528' 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` = '15517' 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` = '15521' 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` = '15514' 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` = '15507' 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` = '15503' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '15491' 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` = '15487' 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` = '15482' 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` = '15476' 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` = '15466' 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` = '15465' 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` = '15454' 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` = '15452' 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` = '15450' 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` = '15440' 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` = '15439' 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` = '15436' 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` = '15432' 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` = '15426' 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` = '15428' 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` = '15422' 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` = '15421' 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` = '15415' 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` = '15413' 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` = '15410' 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` = '15407' 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` = '15405' 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` = '15402' 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` = '15398' 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` = '15395' 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` = '15393' 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` = '15385' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '15383' 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` = '15384' 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` = '15379' 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` = '15375' 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` = '15373' 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` = '15371' 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` = '15367' 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` = '15364' 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` = '15361' 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` = '15360' 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` = '15356' 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` = '15355' 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` = '15345' 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` = '15344' 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` = '15339' 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` = '15333' 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` = '15321' 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` = '15317' 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` = '15313' 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` = '15314' 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` = '15310' 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` = '15306' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

Translate
Olympic Park Casino Event #6: €1M GTD €1,500 NLH Main Event Live Reporting - Day 4

Current Level 38 Current Day 4
Blinds 300,000/600,000 Ante 600,000
Entries 812 Remaining 1
Prize Pool (EUR) €1,052,352 First Prize (EUR) €167,900
1 New Update - Click to refresh
Live Updates - Day 2
09:34 (UTC+2)
Day 2 of Olympic Park Casino Ended
Level: 19     Blinds: 4,000/8,000     Ante: 8,000
Final Day 2 Chip Counts Posted Saturday 27th July, 2024 at 01:22(UTC+2) by Jason Glatzer
Place Name Country Chips Big Blinds
1 Paul Koppe Estonia 1,660,000 111
2 Enea Subashi Greece 1,655,000 110
3 Eriks Krumins Latvia 1,595,000 106
4 Rubens Akopjancs Latvia 1,490,000 99
5 Kaspar Kaisel Estonia 1,465,000 98
6 Yurii Zabrodotskyi Ukraine 1,345,000 90
7 Elias Suhonen Finland 1,260,000 84
8 Ignotas Tamasauskas Lithuania 1,215,000 81
9 Liutauras Armanavicius Lithuania 1,155,000 77
10 Aurimas Stanevicius Lithuania 1,150,000 77
11 Marius Morel Estonia 1,105,000 74
12 Gunnar Wedde Norway 1,090,000 73
13 Vilius Zabarauskas Lithuania 1,070,000 71
14 Robert Kaggerud Norway 900,000 60
15 Evgeny Vyal Estonia 790,000 53
16 Laurynas Vaitkevicius Lithuania 745,000 50
17 Joshua Stewart United Kingdom 735,000 49
18 Aleksei Vandyshev Estonia 690,000 46
19 Andre Villandberg Estonia 585,000 39
20 Roberto Olsen Sweden 565,000 38
21 Jarkko Suokas Finland 560,000 37
22 Ben Slack United Kingdom 530,000 35
23 Christopher Berggren Sweden 515,000 34
24 Daniel Clifford Sweden 505,000 34
25 Nicolai Ejstrud Denmark 500,000 33
26 Nohad Teliani Canada 500,000 33
27 Mairo Tori Estonia 500,000 33
28 Matte Karjalainen Finland 480,000 32
29 Mauri Dorbek Estonia 475,000 32
30 Nicklas Dehli Denmark 465,000 31
31 Bjorn Lindberg Sweden 460,000 31
32 Jeffrey Cormier Canada 455,000 30
33 Sohrab Malkari Norway 455,000 30
34 Ermo Kosk Estonia 445,000 30
35 Niko Ilmonen Finland 440,000 29
36 Roope Tarmi Finland 420,000 28
37 Matias Kesanen Finland 390,000 26
38 Juuso Koskela Finland 370,000 25
39 Tapio Aaltonen Finland 369,000 25
40 Jukka Moisio Finland 360,000 24
41 Henri Katila Finland 325,000 22
42 Risto Parnat Estonia 325,000 22
43 Roman Petelytskyi Ukraine 305,000 20
44 Kriss Riekstins Latvia 300,000 20
45 Andrei Silencov Moldova 290,000 19
46 Tero Kilkanen Finland 285,000 19
47 Espen Sandvik Norway 270,000 18
48 Gregory Telman Israel 270,000 18
49 Markku Koplimaa Estonia 265,000 18
50 Sondre Lunde Norway 260,000 17
51 Mindaugas Kriauciunas Lithuania 255,000 17
52 Robert Rohr Germany 253,000 17
53 Igor Pihela Jr Estonia 245,000 16
54 Krisjanis Stankevics Latvia 235,000 16
55 Andre Grigorjev Estonia 230,000 15
56 Sergei Aleksejev Estonia 228,000 15
57 Martin Piik Estonia 220,000 15
58 Juuso Oksanen Finland 210,000 14
59 Victor Fernandez Garcia Spain 165,000 11
60 Kasparas Klezys Lithuania 162,500 11
61 Jyri Merivirta Finland 154,500 10
62 Janis Leja Latvia 125,000 8
63 Sauli Haapaniemi Finland 115,000 8
64 Rustam Havryliuk Ukraine 115,000 8
65 Vilde Fagerbakke Norway 110,000 7
66 Konstantin Färber Germany 100,000 7
67 Artur Külanurk Estonia 60,000 4
68 Steven Tool Estonia 50,000 3
How The Sviten Was Born Posted Saturday 27th July, 2024 at 01:21(UTC+2) by Lina Olofsson

Once upon a time, there was a card room in a little town called Stockholm. The town where everyone is named after the Nordic mythology has blue eyes and blond hair. It's the middle of Scandinavia where polar bears walk on the streets, every house is filled with furniture from IKEA, and drives a Volvo. 

In this little town, the little card room opened a day during the mid-20s, and the owners named it Sviten (directly translated as the suite). This card room had hundreds of poker players gathering each week to play poker. After endless hours down at Sviten playing every form of poker, there was they started to come up with new games. After many trials and errors one of the owners, Anders Bengtsson, came up with the idea to combine two games in one and play it pot limit. Just like that, the game of Sviten was born. 

The rules of Sviten are as simple as its genius. It's just like playing five-card Omaha AND a five-card draw. The pot is divided into two and one pot goes to the one who has the best hand in Omaha and the other half goes to the one who has the five-card draw hand. But of course, there's a nice twist to everything. After the flop, you can change as many cards as you like from your five-card hand and if you only choose to change one you can have it open and an option to take it or not. Doesn't it sound like fun? At least the Swedes think so and the startup in today's Sviten event here at the Hilton Park shows how popular it is. 

But it's not just the Swedes who started to love the game Sviten (or Drawmaha as it's also called) over the years. So has the Finns, Danes, and Norwegians but so far the only country having a championship of Sviten is Sweden but that's only since 2012. However, after having a look at the starting field it's safe to say that this is a game for the Nordic Vikings. Only 13 of the 102 entries in the event are from somewhere else. 

It's a safe bet to say this probably is the happiest tournament up on til now and surely the loudest so far with many of the familiar faces from the time when the card room Sviten still existed. Sadly the good old card room shut its doors but the card game however continues to live on and will so for many, many years more. 

Micke Doverklint explains the rules of Sviten to Jonas Kovacs

Lena Bjorn

Peter La Terra 

Jens Henrik-Riis or as the Swedes reffers to him as "Dansken" (The Dane)

Many players in the Sviten tournament

Bag'n'Tag - Day 2 Of The WSOPC €1,500 Main Event Is Over Posted Saturday 27th July, 2024 at 00:52(UTC+2) by Alaxandar Georgiev

Level 21: 6,000/12,000 (12,000)
Entries: 68/812


Day 2 is finally over and 68 players will be bagging their stacks for Day 3.

Big Pocket Cooler Right Before Day 3 Posted Saturday 27th July, 2024 at 00:49(UTC+2) by Alaxandar Georgiev

Level 21: 6,000/12,000 (12,000)
Entries: 71/812


Sergei Aleksejev had his 522,000 stack in the middle against one of the chip leaders Kasparas Klezys, the pair were all-in preflop and revealed their cards.

Sergei Aleksejev:
Kasparas Klezys:

No bueno board for Klezys, his opponent's better pocket pair held to the end and it was a huge double-up for Aleksejev right before the end of Day 2.

Samu Aalto busted on a table nearby and won't make it to Day 3.

Player Chips Progress
Sergei Aleksejev 1,074,000 846,000
Kasparas Klezys 980,000 817,500
Samu Aalto 0 0
Last Five Hands For The Day Posted Saturday 27th July, 2024 at 00:40(UTC+2) by Alaxandar Georgiev

Level 21: 6,000/12,000 (12,000)
Entries: 71/812

The floor made the draw and it is going to be five last hands before the end of Day 2. All other players will continue to Day 3 where it all gets a bit more tense.

Three Finland players just busted as well taking home €3,550.

Player Chips Progress
Soile Lerviks 0 0
Henri Tanskanen 0 0
Samuli Hietala 0 0
20 More Players Bust In The Money Posted Saturday 27th July, 2024 at 00:29(UTC+2) by Alaxandar Georgiev

With just 20 minutes left to Day 3, we've had another 20 players bust out, they will be leaving the fight for the golden ring, but will at least take home €3,250  each. The other 72 players have now made the pay jump and will be guaranteed at least €3,550.

Player Chips Progress
Martin Keskkula 0 0
Timmy Anker 0 0
Jussi Mattila 0 0
Mateusz Sikora 0 0
Mateusz Sikora 0 0
Helge Bjorlow 0 0
Sergei Krementsukov 0 0
Pasi Koskelainen 0 0
Vitalii Zimkovskyi 0 0
Ali Far 0 0
Jarmo Juhani Salonen 0 0
Sten Liivand 0 0
Uladzimir Luchkou 0 0
Jaanus Kippel 0 0
Mikko Ylamaki 0 0
David Asquino 0 0
Jaime Susarte 0 0
Jarkko Strom 0 0
Jani Tuovinen 0 0
Ritwik Khanna 0 0
Kilkanen Definetely Loves A Chop-Pot Posted Saturday 27th July, 2024 at 00:24(UTC+2) by Alaxandar Georgiev

Level 21: 6,000/12,000 (12,000)
Entries: 75/812


Tero Kilkanen slipped his last 72,000 chips in the middle and got a call from Robert Kaggerud on the small blind, right before Aurimas Stanevicius re-jammed it on him and Kaggerud snap-called.

Tero Kilkanen:
Robert Kaggerud:
Aurimas Stanevicius:

To the player's surprise, Stanevicius's hand wasn't what they expected to see. He was quite behind for the main pot and one out down for the big side pot.

The board ran-out in Kilkanen's favor as he chopped the pot with Kaggerud and is still alive with 108,000 chips. On the other hand Stanevicius lost the big side pot to Kaggerud for an amount of 888,000 and is left with 160,000.

Player Chips Progress
Robert Kaggerud 888,000 613,000
Aurimas Stanevicius 160,000 590,000
Tero Kilkanen 108,000 58,000
Not A Bad Flop Mr. Grigorjev Posted Saturday 27th July, 2024 at 00:01(UTC+2) by Alaxandar Georgiev

Level 20: 5,000/10,000 (10,000)
Entries: 85/812


Henri Katila raised from an early position and 3 players called, Nicolai Kristian Ejstrud from the button, Andre Grigorjev, and Sohrab Malkari from the blinds.

The flop came and everyone checked. The turn was and Malkari led with a 30,000 bet from the big blind, Ejstrud and Grigorjev both called.

On the river Malkari bet once again, this time it was 50,000 - his bet got raised to 155,000 from Grigorjev. Malkari made the call after a while and his opponent turned and Malkari mucked against the trips.

Player Chips Progress
Andre Grigorjev 650,000 519,000
Sohrab Malkari 640,000 80,000
Luchkou Is Out Of Luck-chou Posted Friday 26th July, 2024 at 23:41(UTC+2) by Alaxandar Georgiev

Level 20: 5,000/10,000 (10,000)
Entries: 85/812

Uladzimir Luchkou (pictured below) shoved his last 25 blinds against a min-raise that Yurii Zabrodotskyi made from the button. Nohad Teliani folded the big blind and the Ukrainian snap called.

Uladzimir Luchkou:
Yurii Zabrodotskyi:

Another bad setup on the felt, Luchkou was very far behind. The flop came and Luchkou paired his Queen, somebody from the table said "Always a sweat". The Belarusian player needed to find more ladies on the last 2 cards but found none on the turn and river.

He finished in 85th place and got a payout of €3,250.

Player Chips Progress
Yurii Zabrodotskyi 730,000 622,000
Uladzimir Luchkou 0 0
Pocket Rockets For Rohr Posted Friday 26th July, 2024 at 23:29(UTC+2) by Alaxandar Georgiev

Level 20: 5,000/10,000 (10,000)
Entries: 88/812

Robert Rohr and Steven Tool both went all-in Preflop for a massive pot on table 19. The German was the player at risk as his opponent had 300,000 more than his 610,000 stack.

Robert Rohr:
Steven Tool:

Bad news for Tool, his opponent had the best starting hand in the game. It got even worse when he saw the and Rohr hit his set of aces. Nothing helped Tool on the next two cards and he lost a massive pot worth 1,250,000 chips.

Player Chips Progress
Robert Rohr 1,250,000 760,000
Steven Tool 300,000 250,000
First 10 Players That Busted In The Money Posted Friday 26th July, 2024 at 23:19(UTC+2) by Alaxandar Georgiev

Level 20: 5,000/10,000 (10,000)
Entries: 93/812

A total of 10 players quickly busted after the bubble burst, check them out below:

Player Chips Progress
Maksym Klopotok 0 0
Martin Kopernicky 0 0
Julia Kuusijarvi 0 0
Julia Kuusijarvi 0 0
Matias Arosuo 0 0
Kalle Parkkinen 0 0
Urmo Velvelt 0 0
Aleksandr Januskevic 0 0
Davis Modans 0 0
Emil Hovmark 0 0
Tommi Lankinen 0 0
Nemo Israel Stone Bubbles In The Worst Way Posted Friday 26th July, 2024 at 23:11(UTC+2) by Alaxandar Georgiev

Level 20: 5,000/10,000 (10,000)
Entries: 104/812



Nemo Israel was left heads-up against Igor Pihela (Jr) on the blinds Pihela 3-bet Israel's raise and they went to the flop. There were more than 200,000 in the middle and the Estonian announced he was all-in and there was the call from Israel for his remaining 200,000 chips.

Nemo Israel:
Igor Pihela (Jr):

Israel was ahead but at risk on the stone bubble. The turn card wasn't very good for him as it gave Pihela additional outs for a flush.

The river was  Jack the Reaper of golden rings and dreams for Nemo Israel. He took the bad bead as a champ and smiled as he was standing up.



Congratulations to the rest 103 players, they will all take home at least €3,000.

Player Chips Progress
Igor Pihela Jr 800,000 630,000
Nemo Israel 0 0
Chip Stack Update On The Big Boys Posted Friday 26th July, 2024 at 22:50(UTC+2) by Alaxandar Georgiev

Marius Morel is leading at the moment with 1,150,000 chips and a total of 5 players have broken the million mark. One of them is Eriks Krumins, our 2024 €555 Ring Event Champion. Can he get another one?

Check the top 10 stacks around the tables down below.

Player Chips Progress
Marius Morel 1,150,000 390,000
Kaspar Kaisel 1,100,000 200,000
Eriks Krumins 1,060,000 294,000
Liutauras Armanavicius 1,000,000 400,000
Marius Morel 1,000,000 240,000
Jussi Mattila 850,000 736,000
Elias Suhonen 770,000 494,500
Aleksei Vandyshev 760,000 60,000
Sohrab Malkari 720,000 130,000
Vitalii Zimkovskyi 700,000 0
Break On The Bubble Posted Friday 26th July, 2024 at 22:27(UTC+2) by Alaxandar Georgiev

All players are going for a 20-minute break, there are currently 104 players left and it's still the stone bubble.

They will return to level 20 - blinds 5,000/10,000 and Ante 10,000. The average stack is 390,000.

Lankinen Triples as Money Bubble Approaches Posted Friday 26th July, 2024 at 22:09(UTC+2) by Jason Glatzer

Level 19: 4,000/8,000 (8,000)
Entries: 105/812

The action is just two players off the money with hand-for-hand play about to begin. One player who didn't bubble was Tomi Lankinen, who just tripled up instead of hitting the rail.

Andre Villandberg opened for 16,000 from the cutoff. Lankinen three-bet shoved a few chips more to 20,000 from the button. Vilius Zabarauskas called from the big blind before Villandberg called as well.

Villandberg and Zabarauskas checked the  runout down. Lankinen turned over the , and this was good enough to win against Villandberg's and Zabarauskas's to triple his stack.

Player Chips Progress
Tommi Lankinen 72,000 1,000
Sevens Good for Berggren Posted Friday 26th July, 2024 at 21:26(UTC+2) by Jason Glatzer

Level 19: 4,000/8,000 (8,000)
Entries: 112/812

Christopher Berggren had his stack of 211,000 committed and was up against Jarkko Strom.

Christopher Berggren:
Jarkko Strom:

Sevens won the flip on the runout for Berggren to double instead of hitting the rail near the money bubble.

Player Chips Progress
Yanis Mehdi Sahli 0 0
Mats Ullereng 0 0
Max Lampenius 0 0
Arto Loikkanen 0 0
Pasi Laihinen 0 0
Pavel Solodovnikov 0 0
Joel Haapio 0 0
Joel Salmirinne 0 0
20:58 (UTC+2)
Start of Level 19
Blinds: 4,000/8,000     Ante: 8,000
Kosk Finds Courage to Call Posted Friday 26th July, 2024 at 20:57(UTC+2) by Jason Glatzer

Level 18: 3,000/6,000 (6,000)
Entries: 119/812

Pasi Sormunen overjammed the river for 198,000 with the on the board when Ermo Kosk went into the tank.

Kosk called a few minutes later and eliminated Sormunen when his was good against .

"I almost folded," Kosk admitted after Sormunen left the table.

Player Chips Progress
Ermo Kosk 650,000 473,500
Edoardo Mancinelli 0 0
Vasyl Tkachenko 0 0
Kimmo Kurko 0 0
Mateusz Wozniak 0 0
Jyrki Lampinen 0 0
Algirdas Sukys 0 0
Steven Seller 0 0
Pasi Sormunen 0 0
Loikkanen Ousts Arovaara Posted Friday 26th July, 2024 at 20:18(UTC+2) by Jason Glatzer

Level 18: 3,000/6,000 (6,000)
Entries: 127/812

Arto Loikkanen (pictured below) opened from an early position before he called a three-bet jam by Tom Arovaara from a late position with his short stack.

Tom Arovaara:
Arto Loikkanen:

Loikkanen ousted his countrymate Arovaara a few dozen spots shy of the money with a better pair after the ran out on the board.

Player Chips Progress
Arto Loikkanen 400,000 330,000
Indre Martoviciute 0 0
Timo Ruuska 0 0
Ishak Noyan 0 0
Pavels Kazakovs 0 0
Tom Arovaara 0 0
20:01 (UTC+2)
Start of Level 18
Blinds: 3,000/6,000     Ante: 6,000
Eliminations Before Break Posted Friday 26th July, 2024 at 19:58(UTC+2) by Jason Glatzer

Player Chips Progress
Cesar Hanouadi 0 0
Jon Kyte 0 0
Eero Abbey 0 0
Kai Lehto 0 0
Mihails Nikitins 0 0
Tim Vanari 0 0
Andrius Mazeika 0 0
Tauno Pajula 0 0
Tero Laurila 0 0
Ricardas Lukauskas 0 0
Jimmy Dewerdt 0 0
Dinner Break Posted Friday 26th July, 2024 at 18:59(UTC+2) by Jason Glatzer

Players are about to go on a one-hour dinner break. You can check out the opening coverage by Alexandar Georgiev of the €1,100 Mystery Bounty before Lina Oloffson also joins him in coverage tomorrow for the bounty pulls and stories.

Big Stacks Just Before Dinner Break Posted Friday 26th July, 2024 at 18:54(UTC+2) by Jason Glatzer

Player Chips Progress
Kaspar Kaisel 900,000 632,500
Sohrab Malkari 850,000 554,500
Aleksei Vandyshev 820,000 105,000
Eriks Krumins 766,000 510,500
Marius Morel 760,000 40,000
Aurimas Stanevicius 750,000 140,000
Rubens Akopjancs 700,000 434,500
Vitalii Zimkovskyi 700,000 240,000
Liutauras Armanavicius 600,000 399,500
Nohad Teliani 592,000 374,000
Evgeny Vyal 523,000 246,500
Roope Tarmi 500,000 404,500
Gunnar Wedde 500,000 0
Kristjan Maasalu 500,000 100,000
Mairo Tori 500,000 126,000
Nemo Israel 450,000 30,000
Kimmo Kurko 411,000 231,000
Jeffrey Cormier 360,000 160,000
"Bet You Have a Small Pair" Posted Friday 26th July, 2024 at 18:40(UTC+2) by Jason Glatzer

Level 17: 2,000/5,000 (5,000)
Entries: 143/812

Katariina Ingerma open-jammed for 115,000 from late position and was called by Jae Han Kim in the small blind.

"Bet you have a small pair," Kim said to Ingerma, who opted not to respond.

Katariina Ingerma:
Jae Han Kim:

"That's a big pair," Kim said. "Maybe an ace will come. Sometimes they come."

A flush came on the board. Kim's board flush didn't beat Ingerma's flush, which included the queen doubling his opponent.

Player Chips Progress
Katariina Ingerma 240,000 159,000
Jae Han Kim 220,000 170,000
Jari Mahonen 0 0
Marko Keskel 0 0
Kasper Mellanen 0 0
Martin Zobel 0 0
Sebastian Sorensson 0 0
Sebastian Wahl 0 0
Frederic Delval 0 0
Vladimir Korzinine 0 0
Sergei Kuznetsov 0 0
Raimondas Zilenas 0 0
Alf Onnestam 0 0
Kaggerud Ousts Golushko Posted Friday 26th July, 2024 at 18:26(UTC+2) by Jason Glatzer

Level 17: 2,000/5,000 (5,000)
Entries: 155/812

Robert Kaggerud opened the button before he called a three-bet shove for 18 big blinds by Dmitry Golushko.

Dmitry Golushko:
Robert Kaggerud:

"Good game," Kaggerud said to Golushko after the ran out on the board.

Player Chips Progress
Robert Kaggerud 275,000 225,000
Teemu Toikkanen 0 0
Kauno Jappinen 0 0
Terje Bremseth 0 0
Heini Puuska 0 0
Baard Dahl 0 0
Alari Arnover 0 0
Modestas Kryzanauskas 0 0
Rene Peterkopf 0 0
Marijus Dirgela 0 0
Tarmo Tammel 0 0
Dmitry Golushko 0 0
Marius Morel Leads at Break Posted Friday 26th July, 2024 at 18:04(UTC+2) by Alaxandar Georgiev

Marius Morel led at the break with 800,000. The average stack is 245,000, with 166 players out of the 812 entries left in the battle.

Check some of the biggest stacks down below:

Player Chips Progress
Marius Morel 800,000 500,000
Aleksei Vandyshev 715,000 145,000
Jarmo Juhani Salonen 700,000 513,500
Mairo Tori 626,000 210,000
Aurimas Stanevicius 610,000 315,000
Kristjan Maasalu 600,000 440,500
Gunnar Wedde 500,000 426,000
Robert Rohr 490,000 30,000
Nemo Israel 480,000 115,000
Mauri Dorbek 470,000 418,000
18:03 (UTC+2)
Start of Level 17
Blinds: 2,000/5,000     Ante: 5,000
Eliminations Before Break Posted Friday 26th July, 2024 at 17:48(UTC+2) by Jason Glatzer

Player Chips Progress
Marita Magi 0 0
Jonas Klaus 0 0
Matias Knaapinen 0 0
Priamo Carta 0 0
Anton Markachev 0 0
Daiva Byrne 0 0
Martins Sulte 0 0
Hannu Ollila 0 0
Ilya Nikiforov 0 0
Nils Veipans 0 0
Touko Berndtson 0 0
Timmo Kaha 0 0
Break Time Posted Friday 26th July, 2024 at 17:44(UTC+2) by Jason Glatzer

The final 166 players are on a 15-minute break. We will update the biggest chips from around the room shortly after the action resumes.

Recent Eliminations Posted Friday 26th July, 2024 at 17:22(UTC+2) by Jason Glatzer
Player Chips Progress
Aurimas Baltutis 0 0
Erik Lindqwist 0 0
Casper Schantz 0 0
Johan Purbe 0 0
Vladislav Ogorodnik 0 0
Johan Alen 0 0
Mihn Thang Ngo 0 0
Rolands Norietis 0 0
Jorn Hval 0 0
Kevin Karenius 0 0
Johan Creutz 0 0
Vita Veidemane 0 0
Bremseth Keeps Running Into Better Pairs Posted Friday 26th July, 2024 at 17:19(UTC+2) by Jason Glatzer

Level 16: 2,000/4,000 (4,000)
Entries: 180/812

Teddy Bremseth came to Tallinn to have some fun and hopefully walk away with a ring. He had a good stack to start the day but was down to just 70,000 when we last walk by him.

"I lost to one short stack with jacks," Bremseth said.

"What did your opponent have?"

"Queens," said 2023 WSOP Circuit Tallinn Winner Jon Kyte who was sitting behind his friend Bremseth at a different table.

We also learned Bremseth doubled another stack with tens vs. kings. Best of luck to Bremseth for either getting it in with a better pair or his lower pairs getting there.

Gross Bustout for Gross Posted Friday 26th July, 2024 at 17:05(UTC+2) by Jason Glatzer

Level 16: 2,000/4,000 (4,000)
Entries: 191/812

We learned from Phil Gross, who is now on the rail and ready to play the €1,100 Mystery Bounty, that he brutally hit the rail in a huge pot.

Gross shared he had on a board for a full house. The third-nuts on the board wasn't enough as his opponent had the second nuts with to end Gross's Main Event run in a gross fashion.

Meanwhile, recent €350 PLO ring winner Aki Pyysing, also recently hit the rail, ending his quest for a second ring.

Player Chips Progress
Henri Antikainen 0 0
Jonas Eriksson 0 0
Mykhailo Mikhalov 0 0
Kaspars Butans 0 0
Akseli Hosia 0 0
Aki Pyysing 0 0
Paulius Vaitiekunas 0 0
Hendrik Uibo 0 0
Jan-Mikael Kesanen 0 0
Hol Persson 0 0
Ryhor Karapanau 0 0
Phil Gross 0 0
More Eliminations Posted Friday 26th July, 2024 at 16:50(UTC+2) by Jason Glatzer

Player Chips Progress
Santtu Leinonen 0 0
Arduini Lorenzo 0 0
Francisco Racionero 0 0
Herli Olop 0 0
Antti Vetelainen 0 0
Joona-Markus Linna 0 0
Egidijus Digrys 0 0
Hanna Heinlo 0 0
Maureen Bloechlinger 0 0
Romans Moskalovs 0 0
Richard Koppel 0 0
Stanislovas Vinicenka 0 0
Antti Perttula 0 0
Boris Smolianskii 0 0
Joonas Karppinen 0 0
Vitalijs Korhs 0 0
Jonatan Fors 0 0
Vitalijs Korhs 0 0
Luka Sorainen 0 0
Harri Karenius 0 0
Jacks-Full for Petelytskyi Posted Friday 26th July, 2024 at 16:43(UTC+2) by Jason Glatzer

Level 16: 2,000/4,000 (4,000)
Entries: 203/812

Before the blinds increased, Roman Petelytskyi opened from early position before Mikko Ylamaki three-bet to 15,000 from the cutoff. Petelytskyi four-bet shoved for 44,000 and Ylamaki instantly tossed a chip in to call.

Roman Petelytskyi:
Mikko Ylamaki:

Petelytskyi cheered after the turn gave him a full house on the runout to stay alive and double his stack.

Player Chips Progress
Mikko Ylamaki 105,000 8,000
Roman Petelytskyi 95,000 45,000
16:37 (UTC+2)
Start of Level 16
Blinds: 2,000/4,000     Ante: 4,000
€193,750 Record Top Prize; 103 Players Paid Posted Friday 26th July, 2024 at 16:22(UTC+2) by Jason Glatzer

Payouts for the Main Event have just been announced by WSOP Circuit tournament director Teresa Nousiainen.

The top 103 entries will each go home with at least a €3,000 min-cash for double the €1,500 buy-in. Sunday's winner will not only win a gold ring and an invite to the $1 million guaranteed WSOP Tournament of Champions freeroll, but also a €193,750 top prize.

The payouts will be posted shortly in the Payouts tab within our coverage.

Recent Eliminations Posted Friday 26th July, 2024 at 16:16(UTC+2) by Jason Glatzer

Player Chips Progress
Christian Steinbo 0 0
Frederico Alves Dos Santos 0 0
Klaudijus Garjonis 0 0
Kyosti Isberg 0 0
Ervin Sagor 0 0
Egon Norden 0 0
Tommy Piiroinen 0 0
Audrius Laimelis 0 0
Mykola Kostyrko 0 0
Christopher Dowling 0 0
Sven Stok 0 0
Vilius Maniusis 0 0
Samuel Polack 0 0
Ville-Tappio Mesiranta 0 0
Ekrem Atush 0 0
Bjorn Samuelsson 0 0
Enrique Martinez 0 0
Ville-Matti Keranen 0 0
Eero Rantala 0 0
Taago Tamm 0 0
Ranno Sootla 0 0
Ritvars Cekalins 0 0
Klaudijus Bajoras 0 0
"I Track All My Flips" Posted Friday 26th July, 2024 at 16:09(UTC+2) by Jason Glatzer

Level 15: 1,500/3,000 (3,000)
Entries: 249/812

Arduini Lorenzo three-bet jammed for about 75,000 from the cutoff and was called by the friendly Frederic Delval, who opened from early position.

Arduini Lorenzo:
Frederic Delval:

Spades were asked for about the flop before another spade came on the turn. The river improved Lorenzo to a flush to stay alive and double his stack.

The table had a good laugh after the hand as they saw Delval take out his phone.

"I track all my flips," which got a laugh from Ignotas Tamasauskas, Indre Martoviciute, and others.

"No, I really do," he said as he took out his phone.

We got a peak from Delval as he scrolled up for us to show that although his flips mostly have a minus sign recently, he has a streak of plus signs in the mix as well.

While Delval has been one of France's most successful players over the years, with more than $600,000 in tracked poker tournament earnings at The Hendon Mob, he doesn't have any WSOP hardware. We wish him the best of luck in that quest.

Player Chips Progress
Frederic Delval 230,000 99,000
Arduini Lorenzo 160,000 63,000
Eliminations Before Break Posted Friday 26th July, 2024 at 15:43(UTC+2) by Jason Glatzer
Player Chips Progress
Sandis Blums 0 0
Jae Han Kim 0 0
Antti Ahlsten 0 0
Phil Gross 0 0
Christopher Dowling 0 0
Santtu Leinonen 0 0
Andrei Mjagkov 0 0
Audrius Laimelis 0 0
Ott Urb 0 0
Vadim Guk 0 0
Mohammed Al-Khazraji 0 0
Record Breaking WSOP Circuit Tallinn Main Event Posted Friday 26th July, 2024 at 15:39(UTC+2) by Jason Glatzer

Level 15: 1,500/3,000 (3,000)
Entries: 249/812

The record-breaking 2024 WSOP Circuit €1,500 Main Event crushed its €1 million guarantee with 812 entries for a €1,052,352 prize pool.

The payouts will be announced shortly. WSOP Circuit Tournament Director Teresa Noisianen handed over the microphone to Olympic Entertainment Group Poker Director Christer Larsson, who made several announcements, including future tour stops and about the launch of OlyBet Poker in Lithuania about an hour ago.

Nousiainen announced the plan of playing for 11 levels on Day 2 with a 60-minute dinner break after two more blind levels.

Also, the tv table just began featuring the red-hot Canadian Jeffrey Cormier. You can check that out at OlyBet.tv.

Player Chips Progress
Sandis Blums 0 0
Jae Han Kim 0 0
Antti Ahlsten 0 0
Phil Gross 0 0
Christopher Dowling 0 0
Santtu Leinonen 0 0
Andrei Mjagkov 0 0
Audrius Laimelis 0 0
Ott Urb 0 0
Vadim Guk 0 0
Mohammed Al-Khazraji 0 0
15:38 (UTC+2)
Start of Level 15
Blinds: 1,500/3,000     Ante: 3,000
Chip Leaders Of Day 2 Posted Friday 26th July, 2024 at 15:34(UTC+2) by Alaxandar Georgiev

Players are still on a break and they will soon return to their seats and continue the fight for the most important ring in the Circuit. 

Martin Piik is one of the players still in Day 2 and with a healthy stack, he managed to do  a few deep runs in last year's WSOPC Tallinn, which included 16th place in the €1,500 Main event, 11th in the 555 Ring Event NLH and a win in the €150 Progressive Bounty side event.

Check out some of the current bigger stacks down below:

Player Chips Progress
Aleksei Vandyshev 570,000 120,000
Robert Rudolf Rohr 520,000 267,000
Jeffrey Cormier 520,000 15,000
Vitalii Zimkovskyi 460,000 146,000
Max Lampenius 425,000 314,000
Mairo Tori 416,000 137,500
Nemo Israel 365,000 192,000
Martin Piik 350,000 33,500
Jani Tuovinen 320,000 121,000
Aurimas Stanevicius 295,000 105,500
Final Three Re-Entry Hands Posted Friday 26th July, 2024 at 15:06(UTC+2) by Jason Glatzer

Level 14: 1,500/3,000 (3,000)
Entries: 241/793

WSOP Circuit Tallinn Tournament Director Teresa Nousiainen announced the final three hands of re-entry. After all the hands are completed, the event will take a 20-minute break.

Late registration will close after the break, and we will know the final prize pool soon after. Shortly after that, the payouts will be announced. Either way, this crushed the 718 entries attracted to this event last year.

More Bustouts Posted Friday 26th July, 2024 at 15:03(UTC+2) by Jason Glatzer
Player Chips Progress
Aleksandr Naumov 0 0
Quang Thanh Doan 0 0
Markus Asikainen 0 0
Ilvars Gudrimovics 0 0
Perttu Lamminpohja 0 0
Roberts Rumba 0 0
Stanislav Smeljov 0 0
Madis Ormisson 0 0
Per Engstrom 0 0
Ranel Kasi 0 0
Aleksandr Geller 0 0
Riho Sagor 0 0
Edgaras Truskauskas 0 0
Sandis Blums 0 0
Rockets Good for Moisio Posted Friday 26th July, 2024 at 14:58(UTC+2) by Jason Glatzer

Level 14: 1,500/3,000 (3,000)
Entries: 255/785

Sven Stok had his short stack in with . Jukka Moisio committed his 73,000 stack with , while Marius Morel woke up with with little choice to also get involved off his healthy stack.

Moisio eliminated Stok while doubling through Morel after the ran out on the board.

Player Chips Progress
Marius Morel 300,000 157,500
Jukka Moisio 200,000 110,000
Sven Stok 0 0
Tamasauskas Wins a Coin Flip Posted Friday 26th July, 2024 at 14:44(UTC+2) by Jason Glatzer

Level 14: 1,500/3,000 (3,000)
Entries: 255/785

Aleksandar Nanchev opened before he called a three-bet jam by Ignotas Tamasauskas (pictured below) to 44,000. The cards were tabled and the players were off to the races.

Ignotas Tamasauskas:
Aleksandr Nanchev:

Jacks were good on the board for Tamasauskas to double his stack through Nanchev.

Player Chips Progress
Ignotas Tamasauskas 95,000 25,000
Aleksandar Nanchev 75,000 103,000
Recent Eliminations Posted Friday 26th July, 2024 at 14:36(UTC+2) by Jason Glatzer
Player Chips Progress
Romans Krasins 0 0
Arturs Daugis 0 0
Marius Hakonsen 0 0
Ingus Arajs 0 0
Mikko Ylamaki 0 0
Ermo Kosk 0 0
Patrizio Lauria 0 0
Tommi Lankinen 0 0
Meelis Ahman 0 0
Ari Soini 0 0
Vidar Assersen 0 0
Ekrem Esker Atush 0 0
Mikael Haapaniemi 0 0
Thomas Nass 0 0
Morten Sikveland 0 0
Jon Ander Martinez 0 0
Kaspars Mamons 0 0
Ladislav Bohunsky 0 0
Sondre Stormyr 0 0
Nicolas Bokowski 0 0
Akseli Paalanen 0 0
Girts Zarins 0 0
Igor Pihela Sr 0 0
Andrii Nikitin 0 0
Andrejs Volkovs 0 0
14:29 (UTC+2)
Start of Level 14
Blinds: 1,500/3,000     Ante: 3,000
A "Gross" Double for Gross Against Kurko Posted Friday 26th July, 2024 at 14:29(UTC+2) by Jason Glatzer

Level 13: 1,000/2,500 (2,500)
Entries: 264/785

Roope Tarmi opened for 5,000, Event #3: €555 NLH champion Phil Gross and another player called before Kimmo Kurko three-bet to 23,000. Roope snap-folded before Gross jammed for 162,000. The other player folded and Kurko called.

Phil Gross:
Kimmo Kurko:

Queens remained ahead after both the flop and the turn. The river pushed Kurko to a set of ladies but this didn't beat the running straight that Gross improved to. The duo more-or-less swapped stacks after the hand.

Player Chips Progress
Phil Gross 360,000 180,000
Kimmo Kurko 180,000 2,000
€1 Million Guarantee Smashed Posted Friday 26th July, 2024 at 14:24(UTC+2) by Jason Glatzer

Level 13: 1,000/2,500 (2,500)
Entries: 271/781

The €1 million guarantee in the €1,500 Main Event has just been smashed, with 772 entries in the mix for a €1,000,512 prize pool and counting.

Now, it is just a matter of how big it will grow with a full level of late registration still open.

Travel Buddies Everywhere Posted Friday 26th July, 2024 at 14:21(UTC+2) by Jason Glatzer

Level 13: 1,000/2,500 (2,500)
Entries: 271/781

We noticed two travel buddies sitting a few seats apart on the same table in 2023 WSOP Circuit Tallinn €1,100 PLO 4&5 champion Jon Kyte and Joshua Stewart. 

Meanwhile, my travel buddy on the Baltic Road Trip to WSOP Circuit Tallinn was also at the same table nearby Event #1: €250 NLH third-place finisher Marius Hakonsen.

"Of course, Joshua is doing good," said Kyte after we returned the question he asked me in between hands about how we were doing. You see those two green chips (100K each)?"

"Did he win any through you?"

"Of course," replied Kyte. "I bet double the pot with a bluff on the river and Josh made the brave call with second pair."

The next hand then began. Kyte opened the button before he called a three-bet shove by Arto Loikkanen to 33,000.

Arto Loikkanen:
Jon Kyte:

"At least one overcard," said Kyte with a shrug.

Neither the overcard nor any other form of help came on the runout for Kyte to double Loikkanen.

Player Chips Progress
Joshua Stewart 250,000 175,000
Jon Kyte 119,000 41,500
Maureen Bloechlinger 105,000 6,500
Arto Loikkanen 70,000 20,000
Marius Hakonsen 37,000 37,000
Recent Eliminations Posted Friday 26th July, 2024 at 14:00(UTC+2) by Jason Glatzer

Level 13: 1,000/2,500 (2,500)
Entries: 284/767

Player Chips Progress
Tarjei Forus 0 0
Modestas Kryzanauskas 0 0
Michal Remenar 0 0
Oleksii Natoptanyi 0 0
Alberto Gonzalez 0 0
Ave Lepik 0 0
Veipans Wants His Green Chip Back Posted Friday 26th July, 2024 at 13:56(UTC+2) by Jason Glatzer

Level 13: 1,000/2,500 (2,500)
Entries: 286/762

Igor Pihela Sr, Julia Kuusijarvi, and Nils Veipans sat side-by-side on Table 29 with more than an average stack with a photo of Kuusijarvi and Veipans below.

"You see that green chip," Veipans said with a smile to us, pointing at Henri Katala's stack in between hands to his 100,000-denominated green chip. "I had more chips. That one was mine, and I want it back. Julia offered me her green chip, but it's not the same,"

Veipans went on to tell us how he lost his green chip. Henri Katila defended his big blind with off a late position open with by Velpans.

Veipans check-called a bet on the flop by Veipans and again after Katila pulled ahead on the turn. A blank hit the river, and Katila check-jammed what he had left to double his stack through Veipans.

Player Chips Progress
Julia Kuusijarvi 240,000 74,000
Nils Veipans 210,000 36,000
Henri Katila 170,000 119,000
Igor Pihela Jr 170,000 36,000
13:43 (UTC+2)
Start of Level 13
Blinds: 1,000/2,500     Ante: 2,500
First Break Posted Friday 26th July, 2024 at 13:25(UTC+2) by Jason Glatzer

Players are on their first break of Day 2 of the Main Event. Blinds will remain the same at 1,000/2,500 (2,500) when the action resumes shortly.

Player Chips Progress
Pasi Sormunen 0 0
Steinn Thanh Du Karlsson 0 0
Henri Wagner 0 0
Tomi Hietala 0 0
Alexander Norden 0 0
Dmitri Damaskin 0 0
Trond Aanestad 0 0
Aurimas Buivydas 0 0
Klaudijus Garjonis 0 0
Kaido Mikk 0 0
Raphael Godard 0 0
Andrejs Harzejevs 0 0
Anton Konnov 0 0
Josep Pastor De Ramon 0 0
Recently Eliminations Posted Friday 26th July, 2024 at 13:02(UTC+2) by Jason Glatzer

Level 12: 1,000/2,500 (2,500)
Entries: 302/745

Player Chips Progress
Timmy Anker 0 0
Miro Mikkola 0 0
Gunnar Wedde 0 0
Pekka Ikonen 0 0
Tanel Merida 0 0
Luigi Tasca 0 0
Jordi Baixas 0 0
Tanel Evert 0 0
Grigorij Rudnik 0 0
Matias Kesanen 0 0
Georgi Abuladze 0 0
Luca Sebastiani 0 0
Jianing Zhang 0 0
Nadezda Guk 0 0
Seppo Parkkinen 0 0
Vytenis Salickas 0 0
Teddy Wyss 0 0
Magnus Pukk 0 0
Kristiana Stauere 0 0
Peter Kvisthammar 0 0
Victor Vozian 0 0
Carl Halvarsson 0 0
Verneri Hakkinen 0 0
Dirgela Dusts Off Short Stack Posted Friday 26th July, 2024 at 12:56(UTC+2) by Jason Glatzer

Level 12: 1,000/2,500 (2,500)
Entries: 302/745

Marijus Dirgela jammed a short stack with from late position before Jukka Moisio came over the top for a bit more with

A king hit the board for Moisio to claim Dirgela's stack. Meanwhile, we keep hearing celebrations from Jeffrey Cormier as he just sent yet another player packing. A story is coming up shortly about Cormier's Main Event adventures leading up to today.

Player Chips Progress
Jukka Moisio 90,000 1,000
Marijus Dirgela 0 0
Cormier And His Six Bullets Posted Friday 26th July, 2024 at 12:54(UTC+2) by Lina Olofsson

The blog met the energetic and always so nice Jeffrey Cormier from Canada a few days ago as he was playing day one of the Main Event. Jeff came outside the hotel to take a break since he had been having some problems getting his hands to hold up and was in for a total of six bullets. 

"Relax, take a deep breath, and be happy you're getting those bad beats early rather than later in the tournament", I said Jeffrey told me he wasn't running that bad and it was not even bad beats that took him out those previous five times (he was still in for his sixth bullet). He had just had a lot of setups so far but had a decent stack on his sixth tryout and was going to make it last. 

"Wow, six bullets", I said and Jeffrey laughed. "Well you know I won all of them so it's fine, I'm actually plus on this trip but surely would like this bullet to be the last", Jeffrey said as he continued giving me the story of how he managed to win these seats. 

"Well, you know, first I played the mega satellite and had so many good hands its was unbelievable. I had aces, kings, queens, and jacks the first levels of the tournament. When the bubble burst I had 550,000 in my stack and we started with 15,000". 

I was still curious about how he won the other five seats and Jeffrey continued telling me how he busted the first time, going down to the casino playing some blackjack. "So, then I won myself a seat at the blackjack table and went up to play again, busted, and went back to the casino where I won another seat playing blackjack and so I did five times". I started laughing and said, "You know you're referring to the blackjack table as a satellite right?". Jeffrey looked at me and smiled. "Yes, it's perfect! I'm in for six bullets and still on the plus side of this trip". 

The last bullet seemed to go his way and he finished day one with a healthy 167,500 in his stack. Starting here today he continued his way of playing and already eliminated three players within the first couple of orbits and sits with a very healthy stack next to the old EPT regular Ishak Noyan from Sweden who leaned over the table as Jeffrey busted two players and said: "It's ok, you take this one and I'll take the next one". 

As we were summing up the article Jeffrey stood up in the tournament room clapping his hands and saying: "Victim number five" as yet another of his opponents stood up and left the table.  

This guy is on fire! 

Player Chips Progress
Jeffrey Cormier 475,000 70,000
12:50 (UTC+2)
Start of Level 12
Blinds: 1,000/2,500     Ante: 2,500
Jeff Cormier on Fire Posted Friday 26th July, 2024 at 12:40(UTC+2) by Jason Glatzer

Level 11: 1,000/2,000 (2,000)
Entries: 319/736

Jeff Cormier has been hot off the bat. We've witnessed one smaller elimination when he sent out a short-stacked player with tens against eight-seven suited. However, there were at least two more before then including a big one against Jari Hurri.

Hurri check-raised the flop before jamming a blank river with his pocket rockets, with both players starting the hand with healthy stacks. Cormier called both times and turned over for trips to grow his stack to one of the largest from around the room.

Player Chips Progress
Jeffrey Cormier 405,000 237,500
Luka Sorainen 0 0
Jari Hurri 0 0
Darius Svirskas 0 0
Rasmus Sepping 0 0
Vitalijus Kuzmicius 0 0
Gintas Dirse 0 0
Erno Suominen 0 0
Jose Domene 0 0
Joona-Markus Linna 0 0
Harijs Erglis 0 0
Gilles Lamy 0 0
Kevin Karenius 0 0
Early Eliminations Posted Friday 26th July, 2024 at 12:29(UTC+2) by Jason Glatzer

Level 11: 1,000/2,000 (2,000)
Entries: 324/729

The field has grown to 729 entries, 36 of which came during the first half of Level 11.

Several players have already hit the rail, as shown below, with some of them already re-entering for a fresh stack of 50,000.

Player Chips Progress
Karl Persson 0 0
Priit Oja 0 0
Kris Tikka 0 0
Hanno Kerem 0 0
Anne Koskinen 0 0
Oliver Gamble 0 0
Kaspars Butans 0 0
Jari Hurri 0 0
Janne Tiitto 0 0
Mika Marttila 0 0
Jako Kuusik 0 0
Jargo Alavali 0 0
Linda Nguyen 0 0
Ranno Sootla 0 0
Jari-Pekka Juhola 0 0
Konstantyn Holskyi 0 0
Short Stack Double for Bohunsky Posted Friday 26th July, 2024 at 12:20(UTC+2) by Jason Glatzer

Level 11: 1,000/2,000 (2,000)
Entries: 331/719

Slovakia's Ladislav Bohunsky was one of the players to late enter to start the day and he is off to a decent start after doubling through Jukka Moisio.

Bohunsky jammed the river for his short stack with the on the board. Moisio tossed a chip in to call and turned over the for the top pair. Bohunsky turned something better and doubled up after tabling the for two pair.

Player Chips Progress
Ladislav Bohunsky 90,000 40,000
Jukka Moisio 70,000 19,000
Flip Lounge Posted Friday 26th July, 2024 at 12:10(UTC+2) by Lina Olofsson

There are different ways to satellite yourself into the tournaments in Tallinn and WSOP Circuit. One of these ways is Flip Lounge. A fun and thrilling way for the one who likes to gamble and is funnier than flipping a coin.

The flip tournaments are run every day to every tournament and basically, it’s ten players who all play one hand and the winner of that hand wins his seat in that specific tournament. So far 15 lucky players have won their flips and not only won a seat into the tournament but also a seat in the WSOPC Mega-Flip held on Saturday where they play for a Kings of Tallinn 2024 Autumn Edition Main Event Package.

For anyone who still wants to join the action you have until Saturday to play in one of these Flip Tournaments to get a seat in the Mega-Flip. You don’t need to win your seat to qualify for this event you just need to attend one of these flips during the week.

Day 2 Begins Posted Friday 26th July, 2024 at 12:08(UTC+2) by Jason Glatzer

Level 11: 1,000/2,000 (2,000)
Entries: 331/719

Cards are in the air to start Day 2 of the Main Event. A total of 26 new players have already gotten into action to bring the field up to 719 entries and counting.

Welcome to Day 2 of the Main Event Posted Friday 26th July, 2024 at 11:54(UTC+2) by Jason Glatzer

Day 2 of the 2024 WSOP Circuit Tallinn €1,500 Main Event is set to begin on Friday at Noon at Olympic Park Casino and the Hilton Tallinn Park.

The €1 million guarantee is expected to be smashed during the early moments of the day with the opening flights attracting 693 entries and 305 survivors. Late registration remains open for the first four blind levels after which time we will know the total field size, prize pool, and payouts.

After late registration closes, blind levels will increase from 40 minutes to one hour in length. This is also the point the live stream begins. Players will bag their stacks after 11 blind levels of play with tomorrow's Day 3 playing down to a final table.

Aleksei Vandyshev was the only player to push their 50,000 opening stack past the 400K barrier with 430,500 in chips. Check out the top 10 chip counts below:

Place Name Country Chips Big Blinds
1 Aleksei Vandyshev Unknown 430,500 215
2 Tom Arovaara Finland 365,500 183
3 Martin Piik Estonia 316,500 158
4 Vitalii Zimkovskyi Ukraine 314,000 157
5 Kyösti Isberg Finland 300,500 150
6 Sohrab Malkari Norway 295,500 148
7 Mairo Tori Estonia 278,500 139
8 Evgeny Vyal Estonia 276,500 138
9 Mykhailo Mikhalov Ukraine 276,000 138
10 Elias Suhonen Finland 275,500 138

Best of luck to all of the players and stay tuned as we report the Main Event at OlyBet.tv.

Day 2 Seat Draw Posted Friday 26th July, 2024 at 03:00(UTC+2) by Jason Glatzer
Table Seat Name Country Chips Chips
1 1 Konstantyn Holskyi Ukraine 26,000 13
1 2 Mikko Tapani Ylämäki Finland 97,000 49
1 3 Risto Pärnat Estonia 171,000 86
1 4 Andrei Silencov Moldova 73,500 37
1 5 Roberts Rumba Latvia 67,000 34
1 7 Alexander Norden Sweden 53,000 27
1 8 Vadim Guk Estonia 149,500 75
2 1 Ignotas Tamasauskas Lithuania 70,000 35
2 2 Indre Martoviciute Lithuania 86,000 43
2 3 Arduini Lorenzo Italy 97,000 49
2 4 Juuso K. A. Koskela Finland 183,000 92
2 6 Enrique Lago Sanchez Martinez Spain 31,500 16
2 7 Gilles Albert Lamy France 39,500 20
2 8 Aleksandar Nanchev Bulgaria 178,000 89
3 1 Jari Pekka Hurri Finland 122,000 61
3 2 Jeffrey Cormier Canada 167,500 84
3 3 Katariina Ingerma Estonia 81,000 41
3 4 Ishak Noyan Sweden 63,500 32
3 5 Priit Oja Estonia 52,000 26
3 6 Harijs Erglis Latvia 49,500 25
3 7 Verneri J. A. Häkkinen Finland 36,000 18
4 1 Francisco Jose Blanco Racionero Spain 85,500 43
4 2 Akseli Timonpoika Paalanen Finland 73,000 37
4 3 Alf Peter Önnestam Sweden 82,500 41
4 4 Karl O.O Persson Sweden 79,500 40
4 5 Andrii Nikitin Ukraine 62,500 31
4 6 Antti T. T. Ahlsten Finland 65,500 33
4 7 Jonas Klaus Germany 81,500 41
5 1 Jani Alexanteri Tuovinen Finland 199,000 100
5 2 Joel Christian Salmirinne Finland 74,000 37
5 4 Ville-Tappio Mesiranta Finland 38,500 19
5 5 Tanel Evert Estonia 48,500 24
5 6 Samu K. P. Aalto Finland 182,000 91
5 7 Enea Subashi Greece 126,500 63
5 8 Egidijus Digrys Lithuania 120,000 60
6 1 Pekka Samuli Ikonen Finland 95,000 48
6 2 Johan S. A. Creutz Sweden 69,000 35
6 3 Igor(Jr) Pihela Estonia 134,000 67
6 4 Edoardo Mancinelli Italy 103,000 52
6 6 Steinn Thanh Du Karlsson Iceland 41,000 21
6 7 Konstantin Färber Germany 46,000 23
6 8 Morten Sikveland Norway 98,000 49
7 1 Tauno Pajula Estonia 96,500 48
7 2 Jianing Zhang Sweden 50,500 25
7 4 Kasper J. O. Mellanen Finland 67,500 34
7 5 Sten Liivand Estonia 88,500 44
7 6 Terje Humio Bremseth Norway 87,000 44
7 7 Ekrem Esker Atush Finland 186,500 93
7 8 Jon Ander Martinez Spain 92,000 46
8 1 Oliver Wenzell Gamble Denmark 44,000 22
8 2 Kasparas Klezys Lithuania 162,500 81
8 3 Jyri Tapio Merivirta Finland 154,500 77
8 4 Björn Johannes Samuelsson Sweden 101,000 51
8 5 Jako Kuusik Estonia 22,000 11
8 7 Kauno Markus Jäppinen Finland 88,000 44
8 8 Kris Tikka Estonia 58,500 29
9 1 Andre Grigorjev Estonia 131,000 66
9 2 Patrizio Lauria Italy 97,500 49
9 3 Björn Stefan Lindberg Sweden 185,000 93
9 5 Grigorij Rudnik Lithuania 46,000 23
9 6 Tanel Merida Estonia 66,000 33
9 7 Ott Urb Estonia 42,500 21
9 8 Priamo Carta Italy 164,000 82
10 1 Jarkko Juhani Ström Finland 143,000 72
10 2 Nadezda Guk Estonia 50,500 25
10 3 Pavel Solodovnikov Estonia 56,500 28
10 4 Timmo Kaha Estonia 99,500 50
10 5 Sebastian Wahl Finland 34,000 17
10 7 Mykola Kostyrko Ukraine 160,000 80
10 8 Gunnar Wedde Norway 74,000 37
11 1 Santtu Kalevi Leinonen Finland 81,500 41
11 2 Thomas Hempel Nass Norway 38,500 19
11 4 Niko Markus Ilmonen Finland 176,000 88
11 5 Michal Remenar Slovenia 68,000 34
11 6 Vitalijs Korhs Latvia 105,000 53
11 7 Vitalii Zimkovskyi Ukraine 314,000 157
11 8 Hanna Heinlo Estonia 68,000 34
12 1 Antti Juhani Perttula Finland 166,500 83
12 2 Ritvars Cekalins Latvia 128,000 64
12 4 Marijus Dirgela Lithuania 99,000 50
12 5 Jukka Juho-Petteri Moisio Finland 89,000 45
12 6 Marius Morel Estonia 142,500 71
12 7 Vilius Maniusis Lithuania 121,500 61
12 8 Mihn Thang Ngo Finland 130,000 65
13 1 Aleksei Vandyshev Unknown 430,500 215
13 2 Kaspars Mamons Latvia 28,500 14
13 3 Vytenis Salickas Lithuania 44,000 22
13 4 Girts Zarins Latvia 54,500 27
13 5 Jonatan J. S. Fors Finland 114,500 57
13 6 Andrejs Volkovs Latvia 62,500 31
13 7 Anton Konnov Estonia 124,000 62
14 1 Elias L. B. Suhonen Finland 275,500 138
14 2 Victor Prior Fernandez Amat Spain 130,500 65
14 3 Jorn Inge Hval Norway 51,000 26
14 4 Madis Ormisson Estonia 33,000 17
14 5 Tapio Ilmari Aaltonen Finland 176,500 88
14 6 Jyrki Olavi Lampinen Finland 70,000 35
14 7 Emil Kristoffer Hovmark Sweden 261,500 131
15 1 Mairo Tori Estonia 278,500 139
15 2 Kristiana Stauere Latvia 73,000 37
15 3 Baard Viggo Dahl Norway 168,000 84
15 4 Martins Sulte Latvia 46,500 23
15 5 Vilius Zabarauskas Lithuania 154,500 77
15 6 Edgaras Truskauskas Lithuania 83,500 42
15 8 Ali Kabiri Far Sweden 214,500 107
16 1 Ave Lepik Estonia 34,000 17
16 2 Boris Smolianskii Israel 121,500 61
16 3 Vitalijus Kuzmicius Lithuania 114,500 57
16 4 Alberto Martinez Gonzalez Estonia 156,500 78
16 6 Mauri Kristjan Dorbek Estonia 52,000 26
16 7 Heini Johanna Puuska Finland 52,000 26
16 8 Luka A. O. Sorainen Finland 52,000 26
17 1 Mykhailo Mikhalov Ukraine 276,000 138
17 2 Kyösti Allan Isberg Finland 300,500 150
17 3 Anne Kristiina Koskinen Finland 91,500 46
17 4 Rubens Akopjancs Latvia 265,500 133
17 5 Tim Topias Vanari Finland 166,000 83
17 6 Stanislav Smeljov Estonia 35,000 18
17 8 Peter Kvisthammar Sweden 36,000 18
18 1 Taago Tamm Estonia 231,000 116
18 2 Sandis Blums Latvia 77,500 39
18 3 Eriks Krumins Latvia 255,500 128
18 4 Nohad Teliani Canada 218,000 109
18 5 Andrei Mjagkov Estonia 151,000 76
18 6 Rolands Norietis Latvia 31,500 16
18 7 Martin Kopernicky Slovakia 121,500 61
19 1 Raimondas Zilenas Lithuania 158,000 79
19 2 Vilde Bystol Fagerbakke Norway 110,000 55
19 3 Miro Allan Mikkola Finland 42,500 21
19 4 Christian Kay Steinbo Norway 42,500 21
19 6 Kevin Viktor Karenius Finland 69,500 35
19 7 Hannu Reijo Tapani Ollila Finland 102,000 51
19 8 Robert Rudolf Rohr Germany 253,000 127
20 1 Gregory Telman Israel 157,000 79
20 2 Eero J. E. Rantala Finland 120,500 60
20 3 Liutauras Armanavicius Lithuania 200,500 100
20 4 Modestas Kryzanauskas Lithuania 110,000 55
20 5 Soile Hannele Lerviks Finland 118,000 59
20 7 Markus Hermanni Asikainen Finland 148,500 74
20 8 Jarmo Juhani Salonen Finland 186,500 93
21 1 Frederico Alves Dos Santos Brazil 135,000 68
21 2 Yurii Zabrodotskyi Ukraine 108,000 54
21 3 Maksym Klopotok Ukraine 59,500 30
21 4 Jaime Cristobal Cases Susarte Spain 149,000 75
21 5 Juuso Johannes Oksanen Finland 170,000 85
21 6 Victor Fernandez Garcia Spain 138,000 69
21 7 Gintas Dirse Lithuania 25,500 13
22 1 Ari Juhani Soini Finland 56,500 28
22 2 Akseli V. J. Hosia Finland 50,000 25
22 3 Tero Tapio Laurila Finland 46,400 23
22 5 Aleksei Smirnov Estonia 127,000 64
22 6 Mateusz Andrzej Sikora Poland 175,500 88
22 7 Marko Keskel Estonia 189,000 95
22 8 Romans Krasins Latvia 74,500 37
23 1 Henri Elias Tanskanen Finland 172,000 86
23 3 Martin Zobel Estonia 84,500 42
23 4 Ingus Arajs Latvia 43,500 22
23 5 Erno Tapani Suominen Finland 47,000 24
23 6 Jordi Conejos Baixas Spain 30,000 15
23 7 Linda M. P. Nguyen Norway 11,000 6
23 8 David Asquino Italy 123,000 62
26 1 Pasi Tapani Sormunen Finland 112,000 56
26 2 Kimmo Matias Kurko Finland 182,000 91
26 4 Carl E. G. Halvarsson Finland 108,000 54
26 5 Klaudijus Bajoras Lithuania 197,500 99
26 6 Matte B.P Karjalainen Finland 149,500 75
26 7 Roope O. O. Tarmi Finland 95,500 48
26 8 Phil Gross Germany 180,000 90
27 1 Aurimas Buivydas Lithuania 64,000 32
27 2 Henri Pietari Wagner Finland 64,500 32
27 3 Egon Norden Estonia 89,000 45
27 4 Sergei Kuznetsov Estonia 126,500 63
27 5 Matias Juhani Kesänen Finland 38,000 19
27 6 Andrius Mazeika Lithuania 151,000 76
27 7 Seppo Paavo Parkkinen Finland 48,000 24
27 8 Sohrab Malkari Norway 295,500 148
28 1 Rasmus Sepping Estonia 33,500 17
28 2 Ben M. P. Slack United Kingdom 76,000 38
28 3 Helge Thorsashaugen Bjorlow Norway 79,000 40
28 4 Daiva Byrne Lithuania 49,500 25
28 6 Mikael Johannes Haapaniemi Finland 53,000 27
28 7 Tarjei Forus Norway 84,500 42
28 8 Aleksandr Naumov Lithuania 31,000 16
29 1 Igor Pihela Estonia 187,500 94
29 2 Julia Karoliina Kuusijärvi Finland 166,000 83
29 3 Nils Veipans Latvia 174,000 87
29 5 Henri Johannes Katila Finland 51,000 26
29 6 Algirdas Sukys Lithuania 80,500 40
29 7 Dmitry Golushko Unknown 143,000 72
29 8 Timmy Sode Anker Denmark 177,000 89
30 2 Johan Erik Alen Finland 64,500 32
30 3 Sebastian Sörensson Sweden 63,500 32
30 4 Mohammed T. M. Al-Khazraji Finland 134,500 67
30 5 Kaspar Kaisel Estonia 267,500 134
30 6 Georgi Abuladze Estonia 51,000 26
30 7 Darius Svirskas Lithuania 26,000 13
30 8 Kalle Elmeri Parkkinen Finland 81,500 41
31 1 Jon Kristian Kyte Norway 160,500 80
31 2 Audrius Laimelis Lithuania 149,000 75
31 3 Jose Larios Domene Spain 19,000 10
31 5 Joshua James Stewart United Kingdom 75,000 38
31 6 Marius Braendhagen Hakonsen Norway 74,000 37
31 7 Maureen Lynn Blöchlinger Switzerland 111,500 56
31 8 Vasyl Tkachenko Ukraine 168,000 84
32 1 Ricardas Lukauskas Lithuania 251,500 126
32 2 Mindaugas Kriauciunas Lithuania 71,000 36
32 3 Hol E. V. Persson Sweden 124,500 62
32 5 John Ingemar Backman Trast Sweden 63,000 32
32 6 Dmitri Damaskin Estonia 56,000 28
32 7 Kaido Mikk Estonia 22,000 11
32 8 Martin Keskküla Estonia 76,500 38
33 1 Rene Peterkopf Estonia 151,000 76
33 2 Frederic B. R. Delval France 131,000 66
33 4 Andre Mägi Estonia 44,000 22
33 5 Tarmo Tammel Estonia 89,500 45
33 6 Artur Külanurk Estonia 117,000 59
33 7 Perttu Reino Ilari Lamminpohja Finland 101,000 51
33 8 Teddy Leonardo Wyss Switzerland 42,500 21
34 2 Christopher Martin Dowling Ireland 181,000 91
34 3 Sondre Stormyr Norway 200,000 100
34 4 Jan-Mikael Juhani Kesänen Finland 161,000 81
34 5 Ranel Käsi Estonia 139,000 70
34 6 Laurynas Vaitkevicius Lithuania 73,000 37
34 7 Pasi Mauri Koskelainen Finland 96,500 48
34 8 Totti Matias Arosuo Finland 105,500 53
35 1 Herli Olop Estonia 121,000 61
35 2 Aleksandr Geller Estonia 147,000 74
35 3 Mika Tapio Marttila Finland 77,500 39
35 4 Luigi Tasca Italy 71,500 36
35 5 Nicolai Kristian Ejstrud Denmark 151,000 76
35 6 Jae Han Kim Norway 266,500 133
35 7 Timo Johannes Ruuska Finland 76,500 38
36 1 Meelis Ahman Estonia 26,000 13
36 2 Rustam Havryliuk Ukraine 109,500 55
36 3 Johan Gabriel Purbe Sweden 87,500 44
36 4 Nicklas Krohn Dehli Denmark 73,500 37
36 5 Luca Sebastiani Italy 140,000 70
36 6 Kaspars Butans Latvia 48,500 24
36 8 Victor Vozian Romania 78,000 39
37 1 Steven Seller Estonia 33,500 17
37 3 Mihails Nikitins Latvia 158,000 79
37 4 Vladislav Ogorodnik Estonia 179,000 90
37 5 Anton Markachev Estonia 219,000 110
37 6 Ranno Sootla Estonia 87,000 44
37 7 Richard Koppel Estonia 87,000 44
37 8 Tommi Petteri Lankinen Finland 71,000 36
38 1 Joona-Markus Juhana Linna Finland 95,000 48
38 2 Per Michael Engström Sweden 120,000 60
38 3 Antti E. E. Veteläinen Finland 243,500 122
38 5 Krisjanis Stankevics Latvia 90,500 45
38 6 Paul Koppe Estonia 91,500 46
38 7 Evgeny Vyal Estonia 276,500 138
38 8 Espen Smorholm Sandvik Norway 90,000 45
39 1 Sondre Smedheim Lunde Norway 95,000 48
39 2 Aurimas Stanevicius Lithuania 189,500 95
39 3 Riho Sagor Estonia 136,000 68
39 4 Uladzimir Luchkou Unknown 273,500 137
39 6 Joel Wilhelm Haapio Finland 126,000 63
39 7 Daniel Mark Clifford Sweden 41,500 21
39 8 Oleksii Natoptanyi Ukraine 43,000 22
40 1 Tomi S. A. Hietala Finland 85,500 43
40 2 Ilvars Gudrimovics Latvia 57,500 29
40 4 Janne J.  K. Tiitto Finland 15,000 8
40 5 Jarkko Juhani Suokas Finland 126,000 63
40 6 Tommy Olavi Piiroinen Finland 91,500 46
40 7 Kristjan Maasalu Estonia 159,500 80
40 8 Trond Aanestad Norway 31,500 16
41 1 Arturs Daugis Latvia 148,500 74
41 2 Andre Villandberg Estonia 93,000 47
41 3 Samuli Tero Hietala Finland 143,500 72
41 4 Kriss Riekstins Latvia 126,000 63
41 5 Ermo Kosk Estonia 176,500 88
41 6 Max Mikael Lampenius Finland 111,000 56
41 7 Roberto Ahane Olsen Sweden 158,000 79
41 8 Klaudijus Garjonis Lithuania 231,000 116
42 1 Yanis Mehdi Sahli France 95,500 48
42 2 Jaanus Kippel Estonia 230,500 115
42 3 Andrejs Harzejevs Latvia 45,000 23
42 4 Josep Pastor De Ramon Spain 43,000 22
42 5 Jari-Pekka Juhola Finland 86,000 43
42 6 Markku Koplimaa Estonia 195,500 98
42 7 Marita Mägi Estonia 183,500 92
42 8 Sergei Krementsukov Estonia 44,000 22
43 1 Ilya Nikiforov Estonia 47,000 24
43 2 Romans Moskalovs Latvia 160,000 80
43 3 Pavels Kazakovs Latvia 106,500 53
43 5 Alari Arnover Estonia 63,500 32
43 6 Nicolas Bokowski Germany 127,000 64
43 7 Janis Leja Latvia 133,000 67
43 8 Hanno Kerem Estonia 24,500 12
44 1 Jussi P. K. Mattila Finland 114,000 57
44 2 Sergei Aleksejev Estonia 228,000 114
44 3 Vidar Skjeggestad Assersen Norway 104,500 52
44 4 Magnus Pukk Estonia 42,500 21
44 5 Quang Thanh Doan Finland 81,500 41
44 7 Aleksandr Januskevic Lithuania 273,500 137
44 8 Juha Matti Nikkola Finland 74,000 37
45 1 Joonas Henrik Karppinen Finland 65,000 33
45 2 Nemo T. O. A. Israel Finland 173,000 87
45 3 Aki T. O. Pyysing Finland 183,500 92
45 4 Jargo Alaväli Estonia 70,000 35
45 5 Martin Piik Estonia 316,500 158
45 6 Tom Valtteri Arovaara Finland 365,500 183
45 8 Ville-Matti Keränen Finland 193,000 97
02:00 (UTC+2)
Day 2 of Olympic Park Casino Started
Level: 11     Blinds: 1,000/2,000     Ante: 2,000
Your search results are valid for . More Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.