0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0067 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-06-21' AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/29/99/updates' ORDER BY `views` DESC

0.0006 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/29/99/updates', 1, '2024-06-21')

0.0003 SECONDS:
SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image FROM `tour_stop_blogs` LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id` LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id` LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id` LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE `tour_stop_blogs`.`id` = '29'

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

0.0207 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0039 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '99' AND `published` = 1

0.0207 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0040 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '116' AND `published` = 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Translate
WSOPC Tallinn Event #2: €1,100 No-Limit Hold'em Live Reporting - Day 2
1 New Update - Click to refresh
Live Updates - Day 1A
The Terminator "Lucky Aki" Pyysing Takes the Lead Going Into the Final in Event #2: €1,100 Posted Sunday 17th September, 2023 at 02:13(UTC+0) by Lina Olofsson

With only 18 people bought in and sitting at their tables when the tournament started at 1 pm today we weren't sure if this would be as big as we had thought but as time went by more and more players entered and with the optional re-entry until the dinner break another success would be a fact under the wings of the WSOP Circuit.

This is just the second event of the fully packed schedule here with 53 events running over 11 days here in Tallinn so it's fair to say that the party has just begun. And when the registration closed we could count to 109 entries in the field leading up to a combined prize pool of €104,640 and 13 spots getting paid.

And it was like something shifted in the whole tournament room after the dinner break. The early chip leaders with their big stacks had a hard time winning these important coin flips overall and when the first break after this we saw a huge change in the chip stacks with players almost counted out now climbing, and climbing, and climbing.

One of these players was the well-renowned Aki Pyysing from Finland. I started calling him "The Terminator" in the coverage and after the tournament had finished Aki laughed and said that's what they used to call him back in the 1990s when he played in Helsinki.

But Aki isn't just lucky. He started playing poker before many of the players in the field still wore diapers and has been on the scene longer than most players. It takes some luck in poker but the consistency and patience he showed during the later part of the day paid off as he now goes into the final table with more than double the amount of chips as the second player - Josh Stewart - when the tournament resumes tomorrow at 1 pm. If you're curious about how everything evolved during today's play you should read the posts in the coverage to see some of the big hands. 

All nine players still in the field are now guaranteed at least €3,050 for their efforts but the winner of this event will not only get one of the amazing golden circuit rings but also €27,840. 

Make sure you tune into the live stream tomorrow not only to follow the resolution of event #1: €555 No Limit Hold'em but also this one as it will be on de secondary feature table right next to it. And obviously, you will get top-notch coverage here on the blog where we will do our best to give you all the interesting hands and everything else happening on and around this thrilling final with several notable players still in. 

The lineup for the final table will look like this: 

1

Aki Pyysing

1,273,000

2

Josh Stewart

573,000

3

Steponas Venckus

323,000

4

Santtu Leinonen

312,000

5

Vidar Assersen

299,000

6

Aleksei Smirnov

185,000

7

Dominik Ostrowski

171,000

8

Manoel Filho

91,000

9

Tanel Evert

45,000

Thank you for today and good night from the Estonian capital! See you tomorrow from the Hilton Park Hotel and Olympic Casino! 

Final Table Seat Draw and Chips Posted Saturday 16th September, 2023 at 23:53(UTC+0) by Lina Olofsson

Chipcount: 

1.

Aki Pyysing

Finland

1,273,000

2.

James Stewart

Ireland

573,000

3.

Steponas Venckus

Lithuania

323,000

4.

Santtu Leinonen

Finland

312,000

5.

Vidar Assersen

Norway

299,000

6.

Aleksei Smirnov

Estonia

185,000

7.

Dominik Ostrowski

Poland

171,000

8.

Manoel Filho

Brazil

91,000

9.

Tanel Evert

Estonia

45,000

Seat draw:

Seat

Name

Country

Chips

1

Aki Pyysing

Finland

1,273,000

2

Tanel Evert

Estonia

45,000

3

Manoel Filho

Brazil

91,000

4

Santtu Leinonen

Finland

312,000

5

Dominik Ostrowski

Poland

171,000

6

Aleksei Smirnov

Estonia

185,000

7

Josh Stewart

Ireland

573,000

8

Vidar Assersen

Norway

299,000

9

Steponas Venckus

Lithuania

323,000

Marco Baglioni Bubbles the Final Table (€2,500) Posted Saturday 16th September, 2023 at 23:29(UTC+0) by Lina Olofsson

That went by fast. We were expecting this to go on for at least another hour or so but the last eliminations went so quickly that we had a hard time catching up. 

The last man busting the tournament and the bubble boy for tomorrow's final table was Marco Baglioni and just like a lot of other players here during the late hours at Hilton Park and Olympic Casino he met his overman in the Finnish terminator Aki Pyysing. 

After the money went in we had the following showdown: 

Pyysing:

Baglioni:

The board ran out and the dust settled in the room as we had our final nine players for tomorrow.

Player Chips Progress
Aki Pyysing 1,273,000 173,000
Marco Baglioni 0 0
Ermo Kosk Eliminated in 11th place (€2,500) Posted Saturday 16th September, 2023 at 23:21(UTC+0) by Lina Olofsson

Ermo Kosk was just eliminated 11th place and we are now on the final table bubble. 

Player Chips Progress
Ermo Kosk 0 0
Some more pictures from today Posted Saturday 16th September, 2023 at 23:16(UTC+0) by Lina Olofsson

We just received some more pictures from our photographer and of course we want to share them with you guys while waiting for the day to come to an end. 

Tapio Aaltonen

Gonzalez Garrido Ignacio

Georgios Tsouloftas

Kaspar Valk

Akseli Paalanen

Kasparas Drazdauskas

Steponas Venckus

Saulius Tumosa

.jpg?t=1694902634694" data-title="WSOPC Tallinn €1100 NLHE Day 1 Steponas Venckus .jpg" data-image-folder="WSOPC-Event-2" data-original-title="WSOPC Tallinn €1100 NLHE Day 1 Steponas Venckus .jpg" aria-describedby="tooltip784003">

Joni Rantamaki eliminated in 12th place (€2,300) Posted Saturday 16th September, 2023 at 23:01(UTC+0) by Lina Olofsson

Joni Rantamaki was just eliminated from the tournament by his fellow countrymen terminator Aki Pyysing. The two of them got the money in pre-flop: 

Pyysing:

Rantamaki:

The board ran out which must have felt utterly hard for Rantamaki who both flopped the flush draw and turned the jack but got beaten by runner-runner flush. He's just unstoppable Mr Pyysing right now. He's up to over a million in chips too so we'll likely see him tomorrow if nothing really strange happens here with two more players to go until we've reached the final nine. 

Player Chips Progress
Aki Pyysing 1,100,000 540,000
Joni Rantamaki 0 0
23:00 (UTC+0)
Start of Level 18
Blinds: 6,000/12,000     Ante: 12,000
Pyysing Still Holds the Fort Posted Saturday 16th September, 2023 at 22:49(UTC+0) by Lina Olofsson

With 12 players remaining our favorite Finn Aki Pyysing still holds the baton with three times the average stack (272,500). 

Even though his stack seems to have decreased a bit that was only an illusion after the latest color-up when they put the 25k chips into play. Right next to Pyysing, we have another man who's not too uncomfortable either after eliminating the past four out of five players from the tournament. Mister Steponas Venckus from Lithuania. 

22:30 (UTC+0)
Start of Level 17
Blinds: 5,000/10,000     Ante: 10,000
The Man of the Hour Posted Saturday 16th September, 2023 at 22:30(UTC+0) by Lina Olofsson

Steponas Venckus surely is the man of the hour here in a pretty empty ballroom at Hilton Park as we're closing into the final nine players in event two of WSOPC. 

Blinds are 5,000/10,000 (BBA 10,000) and the average stack is 272,500.

.jpg?t=1694900176689" data-toggle="tooltip" data-placement="top" title="WSOPC Tallinn €1100 NLHE Day 1 Steponas Venckus .jpg" data-title="3774020093207434604756871568961684289601313n.jpg" data-image-folder="WSOPC-Event-2" data-original-title="WSOPC Tallinn €1100 NLHE Day 1 Steponas Venckus .jpg" aria-describedby="tooltip793362">

Two In a Row Posted Saturday 16th September, 2023 at 22:12(UTC+0) by Lina Olofsson

It seems like someone's in a streak right now. Steponas Venckus just busted two more players and without all of the tension on the bubble we are now in the money just like that. 

It was just a couple of hands at his new table when it was time for Steponas Venckus to find another golden spot to get his chips in. This time it was against Roope Tarmi and Saulius Tumosa and it all went in before the flop. 

Saulius Tumosa:

Roope Tarmi:

Steponas Venckus:

The board ran out

The tournament director announced: "Okay players, there's no bubble because you are now all in the money. Congratulations!"

All players are now guaranteed at least €2,300 for their efforts in this event. 

Player Chips Progress
Steponas Venckus 430 259,570
Saulius Tumosa 0 0
Roope Tarmi 0 0
22:02 (UTC+0)
Start of Level 16
Blinds: 4,000/8,000     Ante: 8,000
Two Birds With One Stone Posted Saturday 16th September, 2023 at 21:54(UTC+0) by Lina Olofsson

Steponas Venckus just busted two players in the same hand and just like that we're closing in on the bubble here in the €1,100 event. 

All the money went in before the flop with Andrey Koks pushing all his chips over the line with a pair of nines on the hand and Georgios Tsouloftas pushing behind him with . Steponas Venckus looked down on from the big blind and made the call covering both of them. 

Flop:

Turn:

River:

After double checking the stacks making sure Lituania's Venckus had them both covered all the chips went his way while the two others hit the door and we are now down to the last two tables. 

Player Chips Progress
Steponas Venckus 260,000 168,000
Andrey Koks 0 0
Georgios Tsouloftas 0 0
Albert Ostrovskij Hits the Exit Posted Saturday 16th September, 2023 at 21:41(UTC+0) by Lina Olofsson

We just busted two players in the tournament. The last man out was Lithuania's Albert Ostrovskij who busted in 19th place leaving us with six players until we are finally in the money in event number two of many more to come during the next nine days of excitement here in Tallinn and WSOPC. 

Player Chips Progress
Albert Ostrovskij 0 0
Smile! You're On Camera! Posted Saturday 16th September, 2023 at 21:36(UTC+0) by Lina Olofsson

Here are some more pictures from the tournament taken by our fabulous photographer Elena Kask. Enjoy! 

Aleksei Smirnov

Arthur Boatman and AkiPyysing

Kaspar Valk

Aki Pyysing

Joshua Stewart

Santtu Leinonen

Vidar Assersen

Manoel Filho

Albert Ostrovskij

Jouni Hakosalo

21:19 (UTC+0)
Start of Level 15
Blinds: 3,000/6,000     Ante: 6,000
A Very Quiet Level Posted Saturday 16th September, 2023 at 21:19(UTC+0) by Lina Olofsson

Not much has happened during this last level before the break the players are on now. While they are away we're going to have some chip counts. We lost one player which leaves 20 players coming back and seven more to go before we're in the money in this event. 

Anyone's Game Posted Saturday 16th September, 2023 at 20:36(UTC+0) by Lina Olofsson

The blind level just popped up to 2,000/4,000 (4,000) and to be honest we think there's just one player who feels he can sit and wait for his turn in this tournament right now and that's Aki Pyysing who still holding down the fort with his huge stack and his arms crossed around his waist. 

A lot of the players have around an average stack which is 149,000 or just under. You can really feel the tension in here right now as players wait to find the right two hole cards to make some magic happen. 

20:30 (UTC+0)
Start of Level 14
Blinds: 2,000/5,000     Ante: 5,000
Leinonen Takes a Big Pot from Kosk Posted Saturday 16th September, 2023 at 20:28(UTC+0) by Lina Olofsson

Ermo Kosk and Santtu Leinonen were involved in a hand when we arrived at the table. 

Kosk check-called Leinonen's bet of 21,000 on the turn with the board reading . River came which Kosk also checked and Leinonen decided to do the same. 

Kosk:

Leinonen:

Busted flush draw and a hit wasn't good enough to beat the kings and Santtu Leinonen added a well deserved 50,000 to his stack. 

Player Chips Progress
Santtu Leinonen 185,000 0
A Chip and a Chair for Ranta-Nilkku Posted Saturday 16th September, 2023 at 20:12(UTC+0) by Lina Olofsson

Joona Ranta-Nilkku finds himself down to just above one big blind after losing a huge pot to Vidar Assersen from Norway. 

Ranta-Nilkku called the bet of 25,000 on the river on a board with only 5,500 behind and when Assersen turned over his Ranta-Nilkku's hand went to the muck and he's now patiently waiting for a hand to push with. Lucky for him he has a few more hands before the big blind will automatically put him all-in. 

But it's like they say. A chip and a chair. Everything can happen in poker. 

Player Chips Progress
Joona Ranta-Nilkku 5,500 45,500
Re-draw Posted Saturday 16th September, 2023 at 20:03(UTC+0) by Lina Olofsson

As the players are now down to the final 24 the tournament staff is doing a re-draw for the remaining three tables and we have a smaller break to let all the players take their new seats. 

Lucky Aki Posted Saturday 16th September, 2023 at 20:00(UTC+0) by Lina Olofsson

We just overheard our new chip leader Aki Pyysing talking to our fellow live reporter Juhani telling him about when he used to play in Russia back in the days. "They called me Lycky Aki", Pyysing smiled and looked over his huge pile of chips. 

We also got to know how he managed to get the chips before the hand with queens over jacks. He apparently flopped the nut flush versus his opponent who also flopped a flush with his

"You have to have some luck", Pyysing commented as he took a sip of his huge glass of water leaning back and for now can relax as all the shorter stacks struggles to survive on the new blinds of 2,000/4,000 (4,000). 

19:55 (UTC+0)
Start of Level 13
Blinds: 2,000/4,000     Ante: 4,000
Tsouloftas doubles through Kosk Posted Saturday 16th September, 2023 at 19:51(UTC+0) by Lina Olofsson

Early bird chip leader Georgios Tsouloftas was down to only 35,000 when he found a necessary double-up through Ermo Kosk with vs.

The board running out made our fellow Cypriot sigh of relief as he raked the chips and could continue his journey in this tournament. 

Player Chips Progress
Ermo Kosk 85,000 36,000
Georgios Tsouloftas 75,000 40,000
Meet Canada's Kelly Kellner Posted Saturday 16th September, 2023 at 19:41(UTC+0) by Jason Glatzer

Pyysing eliminates Vladislav Topilskiy Posted Saturday 16th September, 2023 at 19:37(UTC+0) by Lina Olofsson

Ladies and gentlemen. We have a new chip leader in the tournament and that's after the biggest pot in the tournament so far. 

It was before the flop the money went in between Vladislav Topilskiy and Aki Pyysing with vs. . No jack and the 300,000 pot went all the way to the other side of the table and Topilskiy was eliminated from the tournament while the Finn Aki Pyysing now holds the chip lead with over 560,000 in front of him. 

Player Chips Progress
Aki Pyysing 560,000 425,000
Vladislav Topilskiy 0 0
Down to Four Tables Posted Saturday 16th September, 2023 at 19:33(UTC+0) by Lina Olofsson

It seems like the short-stacked players have had a hard time trying to double up. Instead, they busted like flies the past five minutes and we've broken yet another table and are now down to the final four. Three to go before we can call it a night. 

32 players remain. The average stack is 105,000 and the blinds are 1,500/3,000 (3,000). 

19:24 (UTC+0)
Start of Level 12
Blinds: 1,500/3,000     Ante: 3,000
Winner takes home €27,840 Posted Saturday 16th September, 2023 at 19:11(UTC+0) by Lina Olofsson

The prize pool was just announced and 13 players will be paid in this tournament with a first price on top of €27,840. If you make it amongst the 13 you will be guaranteed €2,300 for your effort. 

Check out the full payout structure below:

Place

Prize

1

€27,840

2

€19,300

3

€13,200

4

€9,650

5

€7,400

6

€5,950

7

€4,900

8

€3,750 

9

€3,050

10-11

€2,500

12-13

€2,300

 

Table Break! Posted Saturday 16th September, 2023 at 19:07(UTC+0) by Lina Olofsson

For the first time in the tournament, a table has been broken and just after a few minutes another one also broke. That leaves us with five tables with the 39 remaining players remaining in the field.

Shuffle Up and Deal! Posted Saturday 16th September, 2023 at 19:02(UTC+0) by Lina Olofsson

We are back! 

Another seven players felt the urge to throw some chips around and bought in during the dinner break and now with the registration closed we officially have 109 players in this tournament and a three-figure prize pool of nothing less than €104 640 to play for. 

We continue the play with the blinds of 1,000/2,500 with a big blind ante of 2,500. Shuffle up and deal! 

18:57 (UTC+0)
Start of Level 11
Blinds: 1,000/2,500     Ante: 2,500
Tarmi in the Lead during the Dinner Break Posted Saturday 16th September, 2023 at 18:56(UTC+0) by Lina Olofsson

It's very very even between the five stacks in the top now when the players are on their way back to their seats in the €1,100 No Limit Hold'em event but with a couple of chips Finlands Roope Tarmi is in the lead with 159,00 just before Estonias Vladislav Topilskiy with 155,000 and his fellow countryman Aleksei Smirnov with 153,000.

Click on Chip Counts to see all the updated stacks from across the tournament. 

1 Roope Tarmi 159,000  129,000
2 Vladislav Topilskiy 155,000  125,000
3 Aleksei Smirnov 153,000  123,000
4 Dominik Ostrowski 148,000  118,000
5 Igors Ljadovs 143,000  113,000
Learn What It's Like to be a Poker Dealer Posted Saturday 16th September, 2023 at 18:42(UTC+0) by Jason Glatzer

18:27 (UTC+0)
Start of Level 10
Blinds: 1,000/2,000     Ante: 2,000
Last Three Hands Posted Saturday 16th September, 2023 at 17:50(UTC+0) by Lina Olofsson

The tournament director just announced that we will play the last three hands and then it's time for the dinner break. 

While the players enjoy a good steak at The Able Butcher on the second floor or something else delicious we're going to count some chips. 

Syntax Error Posted Saturday 16th September, 2023 at 17:46(UTC+0) by Lina Olofsson

You all have to excuse me. Even though I've done this for some time now a few years off live reporting I made an error previously in the blog. We are not playing a specific amount of levels today. We are playing down to the final table of nine players nothing else.

Maybe if it goes very, very late the players (your reporter) probably prefer to have a good night's sleep and continue tomorrow with the live-streamed final but the plan is to play down to the final tonight which hopefully won't be too late as the tournament experts have predicted but as you know, with poker everything can happen. 

We have a few minutes left of the tenth level of today and then it's time for dinner break for one hour. The tournament will then resume right before nine o'clock. 

Picture Time! Posted Saturday 16th September, 2023 at 17:36(UTC+0) by Lina Olofsson

Our brilliant photographer Elena Kask took some brilliant pictures from the tournament area earlier and here are some of them. 

Ken Okada

Markuu Koplimaa


Joona Ranta


Igors Ljadovs

Sebastian Wahl


Markku Koplimaa


Miguel Cravero


Chris Riander Ounapuu

Ilya Nikiforov


Albert Ostrovskij


Tapio Aaltonen


Dominik Ostrowski

Meet Taago Tamm Posted Saturday 16th September, 2023 at 17:24(UTC+0) by Jason Glatzer

Queens Good for Pihela Senior Posted Saturday 16th September, 2023 at 17:20(UTC+0) by Lina Olofsson

Both Estonian Pihela Senior and Junior are here playing in the field today. Senior Igor Pihela surely would need a double-up coming back fresh from the break. The blinds on 1,000-1,500 (1,500) and just above 20,000 in front of him he looked down on a good hand to shove. 

The good old Pihela Senior got one caller by Aleksei Smirnov and we had a showdown: 

Pihela:

Smirnov:

The board ran out:  and even though Pihela Senior didn't need it he doubled up to 54,000 with a full boat.

Player Chips Progress
Aleksei Smirnov 103,000 24,500
Igor Pihela Sr 51,000 31,000
Koks Takes the Lead going into Level 9 Posted Saturday 16th September, 2023 at 17:01(UTC+0) by Lina Olofsson

We've checked on the chips while the players were on a 20-minute long break and we have a new chip leader. Andrey Koks from Estonia has the lead now with 49 players in the field of the 96 entries made today. He has a comfortable 158,000 in front of him.

But like we've said before it's not too late yet. Whoever wants to buy into the tournament they'll have until the dinner break or as we previously mentioned at the end of level number 10. 

Right behind Koks we have Dominik Ostrowski with 148,000. Both players had a good run over the past two levels and built their stacks very nicely. 

The rest of the updated chip counts you'll find under the tab above. 

Player Chips Progress
Andrey Koks 158,000 0
16:53 (UTC+0)
Start of Level 9
Blinds: 1,000/1,500     Ante: 1,500
Color Up during the Second Break Posted Saturday 16th September, 2023 at 16:30(UTC+0) by Lina Olofsson

The players just went for their second break of the day and while they're at it we'll get some more chip counts for you guys. At the same time, we're doing a color-up on all the 100 chips. 

When they come back it's another two more levels of 30 minutes each until they have their dinner break.

Second Bullet Better for Filho Posted Saturday 16th September, 2023 at 16:18(UTC+0) by Lina Olofsson

Manuel Filho busted his first bullet but the second one he tried out here today seems to have been a better one since he almost tripled it already after less than an hour of play. 

We're still waiting for pictures from today's tournament but our photographer works as hard as she can and as soon as they're ready you'll see them pop up here in the live reporting. 

We are up to 88 entries in the tournament. 

Player Chips Progress
Manoel Filho 80,000 0
Almost Halfway Through Posted Saturday 16th September, 2023 at 16:04(UTC+0) by Lina Olofsson

We just proceeded to level eight of today's 16 in total. Blinds are now 600-1,200 (1,200). Expected time to wrap it up today is a bit before midnight. 

We're up to 82 entries in this tournament and 51 remaining. 

If you head over to our chip counts page you'll find some updated stacks and a few new ones. 

15:58 (UTC+0)
Start of Level 8
Blinds: 600/1,200     Ante: 1,200
Tarmi Top Three Posted Saturday 16th September, 2023 at 15:57(UTC+0) by Lina Olofsson

With Georgios Tsouloftas and Martin Sedlak over at table number four, I found someone who's been building his stack a bit quieter. Roope Tarmi is the third player today to build his stack above the 100k mark. 

Player Chips Progress
Roope Tarmi 112,000 82,000
Sedlak Builds Up Posted Saturday 16th September, 2023 at 15:52(UTC+0) by Lina Olofsson

Martin Sedlak has done a great job building up his stack over the past level and seems to have taken some of Georgios Tsoulofta's chips. He sits now with a comfortable 114,000 in front of him. Something I suppose hasn't been the easiest task since he has Tsouloftas two steps to his left and on a, so far, very aggressive table with action almost every hand. 

Player Chips Progress
Martin Sedlak 114,000 43,000
Meet Estonian Poker Beast Ranno Sootla Posted Saturday 16th September, 2023 at 15:50(UTC+0) by Jason Glatzer

New Level, More Players Posted Saturday 16th September, 2023 at 15:35(UTC+0) by Lina Olofsson

We just kicked it up a notch and are now playing on level number seven of today and the blinds are up to 500/,1000 with big blind ante on 1,000. 

The tournament clock announces that there are 78 entries now. A number that will most likely increase by the time we reach the end of level 10 which is the last level to buy-in och do a re-entry. 

15:32 (UTC+0)
Start of Level 7
Blinds: 500/1,000     Ante: 1,000
Tsouloftas Busts Ucero and Takes Further Lead Posted Saturday 16th September, 2023 at 15:32(UTC+0) by Lina Olofsson

Level 6: 400/800 (800)

Georgios Tsouloftas is on a winning streak right now and Jesus Ucero didn't have a chance when he tried a three-barrel bluff on today's chip leader. 

Tsouloftas raised pre-flop and was called by Mika Ramunas and Ucero in the blinds. 

The flop was checked to Tsouloftas who c-bet 1,700. Ramunas got out of the way while Ucero check-raised to 5,100. Tsouloftas called. 

Ucero then bet 5,700 on the on the turn which also was called by his opponent. 

When the river came Ucero instantly went all-in for 16,900 and Tsouloftas thought for a while but decided to call. Ucero turned around (Queen high) which wasn't good enough against Tsouloftas kings and Ucero left the table while our chip leader now has increased his advance further. 

Player Chips Progress
Georgios Tsouloftas 124,000 32,000
Jesus Ucero 0 0
Video Highlights From Day 2 Posted Saturday 16th September, 2023 at 15:02(UTC+0) by Jason Glatzer

Friday was another fantastic day at the WSOPC Tallinn at Olympic Park Casino and the Hilton Tallinn Park.

Check out the video highlights from Day 2 below:

The Price on Poker Just Went Up Posted Saturday 16th September, 2023 at 14:59(UTC+0) by Lina Olofsson

With 71 entries and 52 players remaining in the field, we now have an average stack of 41,000. 

The blinds are now up to 400/800 (800). 

14:56 (UTC+0)
Start of Level 6
Blinds: 400/800     Ante: 800
Tsouloftas Takes a Steady Lead Posted Saturday 16th September, 2023 at 14:54(UTC+0) by Lina Olofsson

The first four levels of WSOPC Tallinn Event #2 were very successful or Cypriot Georgios Tsouloftas who had 92,000 when the players went on today's first break. With three times starting stack he has taken a good lead of the field of 69 players. 

Behind Georgios, we have Germanys Martin Sedlak with a steady 71,000. 

Below you'll find some more big stacks and notable players in today's field. 

1 Georgios Tsouloftas 92,000  62,000
2 Martin Sedlak 71,000  41,000
3 Dominik Ostrowski 69,000  39,000
4 Igor Pihela 60,000  30,000
5 Masoud Mirza Mohammadi 59,000  29,000
6 Akseli Timonpoika Paalanen 54,000  24,000
7 Tadas Karosas 49,000  19,000
8 Tapio Aaltonen 44,000  14,000
9 Ermo Kosk 43,500  13,500
10 Kimmo Mathias Kurko 35,000  5,000
11 Joona Ranta-Nilkku 34,000  4,000
12 Igors Ljadovs 33,000  3,000
13 Aki Pyysing 32,000  2,000
14 Jesus Ucero 32,000  2,000
Change of scenery Posted Saturday 16th September, 2023 at 14:49(UTC+0) by Lina Olofsson

Players are back from break and meanwhile the 55 players who took their well deserved break after four intense levels at the tables a lot of thing happened. Not only did 14 new players buy themselves into the tournament. The whole crowd also moved into the Main Ballroom here at Hilton Park and Olympic Casino.

14:43 (UTC+0)
Start of Level 5
Blinds: 300/600     Ante: 600
20 Minute Leg Stretcher Posted Saturday 16th September, 2023 at 14:06(UTC+0) by Lina Olofsson

This event is a re-entry as we previously mentioned and the players can, if busting out, re-enter the tournament for another €1,100 if they're up for it. So far we have 55 entries but players can both buy-in or re-enter until the end of the 10th level. As we are approaching the first break of the day we are going to run around and collect some chip counts for you to enjoy yourself with while the players go on a well-deserved 20-minute break in a few minutes. 

See you soon! 

Holma Fires Another Bullet Posted Saturday 16th September, 2023 at 14:00(UTC+0) by Lina Olofsson

Finland's Roope Holma is the first player to buy in a second time to the tournament after busting his first stack. 

Good luck Holma! Let's hope it's not the third time a charm but instead the second one in this case.

Player Chips Progress
Roope Holma 30,000 0
Level four is on! Posted Saturday 16th September, 2023 at 13:52(UTC+0) by Lina Olofsson

Everything seems to go so quickly when you're enjoying yourself, isn't it? We're already on today's fourth level of action here today and another player just bought himself into the WSOPC Tallinn €1,100 event number two. 

Here's a list of today's players so you can have a look for yourself if you find your favorite on there. 

Tapio Aaltonen

30,000

Alessandro Angotti

30,000

Lucas Miguel Cravero

30,000

Kasparas Drazdauskas

30,000

Tanel Evert

30,000

Victor Fernandez Garcia

30,000

Ignacio Gonzalez Garrido

30,000

Kert Hallik

30,000

Roope Holma

30,000

Vladimir Iljunin

30,000

Tadas Karosas

30,000

Osku Kalle

30,000

Andrey Koks

30,000

Marco Kölle

30,000

Kevin Kõnd

30,000

Ermo Kosk

30,000

Eriks Krumins

30,000

Kimmo Matias Kurko

30,000

Matti Lasanen

30,000

Igors Ljadovs

30,000

Jesus Martinez Ucero

30,000

Mika Ramunas

30,000

Masoud Mirza Mohammadi

30,000

Arminas Nemeika

30,000

Stanislovas Norkus

30,000

Dominik Ostrowski

30,000

Chris Riander Ounapuu

30,000

Akseli Timonpoika Paalanne

30,000

Igor Pihela (Sr)

30,000

Aki Pyysing

30,000

Joni Rantamäki

30,000

Joona Ranta-Nilkku

30,000

Martin Sedlak

30,000

Rasmus Sepping

30,000

Ruslan Stserbjuk

30,000

Taago Tamm

30,000

Tarmo Tammel

30,000

Roope Tarmi

30,000

Georgios Tsouloftas

30,000

Saulius Tumosa

30,000

Kaspar Valk

30,000

Uku Valner

30,000

Steponas Venckus

30,000

Daniele Venditti

30,000

Sebastian Wahl

30,000

13:37 (UTC+0)
Start of Level 4
Blinds: 200/500     Ante: 500
Though Start for Finland Posted Saturday 16th September, 2023 at 13:36(UTC+0) by Lina Olofsson

We are now up to 51 entries in the €1,100 No Limit Hold'em Event#2 of the WSOPC here in Tallinn. So far six of these have already made their way to the door and three out of the six are from the neighboring country Finland. 

Player Chips Progress
Ruslans Margin 0 0
Markus Ristola 0 0
Roope Holma 0 0
Ken Okada 0 0
Manoel Filho 0 0
Joona Ranta-Nilkku 0 0
Red, Blue, Black or Silver? Posted Saturday 16th September, 2023 at 13:30(UTC+0) by Lina Olofsson

Just like if we had been in the fabulous Las Vegas and the World Series, here in Tallinn, we have four different tournament rooms. The Main tournament room is in the Grand Ballroom which is the Blue area. Right next door we have the Red area where the players in this event are gathered and enjoying themselves. Outside these two tournament rooms, we have the Black area which is in the lobby area. On the opposite of these, we have the fourth and last tournament area which is the Silver one.  

And what would a WSOP tournament be without a feature table and a secondary feature table right? Here in Tallinn, you can find the glorious feature table just to the right after you've entered the stairs up from the Hotel lobby. The live streaming will start off by tomorrow with the final day of the very first event of this WSOPC which is the €555 No Limit Hold'em. But don't worry this tournament will be streamed right next to that final table with cameras so you can follow the action first hand.

This is the first time WSOP Circuit is coming to the Estonian capital Tallinn but my guess is it won't be the last because so far it has lived up to everything you possibly can expect as a player. Both when it comes to the tournaments with the amazing staff and also Hilton Park is surely living up to its five stars and has the best service you can imagine. 

Third Level of the Day Posted Saturday 16th September, 2023 at 13:08(UTC+0) by Lina Olofsson

The third level of day on in the #2 WSOPC Tallinn is running and we are up to 41 entries in the tournament with two players already done and dusted. 

The second player to bust was Finland's Roope Holma. 

Player Chips Progress
Roope Holma 0 0
13:04 (UTC+0)
Start of Level 3
Blinds: 200/400     Ante: 400
First Player to Bust Posted Saturday 16th September, 2023 at 13:04(UTC+0) by Lina Olofsson

We had our first elimination in the tournament and it was Magrins Ruslans. So far it doesn't seem like he fired another bullet. We're up to 34 entries in the field and just about to start level three of the day. 

Player Chips Progress
Magrins Ruslans 0 0
12:43 (UTC+0)
Start of Level 2
Blinds: 100/300     Ante: 300
21 players in Posted Saturday 16th September, 2023 at 12:24(UTC+0) by Lina Olofsson

Three more players have made their way into the €1,100 No Limit Hold'em event. 

So far these are the competitors: 

Tapio Aaltonen

30,000

Miguel Cravero

30,000

Manoel Filho

30,000

Victor Garcia

30,000

Vladimir Iljunin

30,000

Osku Karttunen

30,000

Marco Kalle

30,000

Kevin Kõnd

30,000

Igors Ljadovs

30,000

Jesus Ucero

30,000

Ramunas Mika

30,000

Ken Okada

30,000

Dominik Ostrowski

30,000

Chris Riander Ounapuu

30,000

Igor Pihela

30,000

Markus Ristola

30,000

Martin Sedlak

30,000

Rasmus Sepping

30,000

Georgios Tsouloftas

30,000

Kaspar Valk

30,000

Steponas Venckus

30,000

Player Chips Progress
Manoel Filho 30,000 0
Miguel Cravero 30,000 0
Tapio Aaltonen 30,000 0
Cards are in the air! Posted Saturday 16th September, 2023 at 12:15(UTC+0) by Lina Olofsson

We have 18 players so far spread over four tables in the red room next to the main ballroom here at Hilton. But we expect more eventually since players often late registering for some events. Particularly when it's like this one, a re-entry one. 

11:51 (UTC+0)
Start of Level 1
Blinds: 100/200     Ante: 200
WSOPC Tallinn Event #2: €1,100 NLH Begins at 2 p.m. Posted Saturday 16th September, 2023 at 11:44(UTC+0) by Lina Olofsson

Welcome to the live report from the second event of WSOPC here in the Estonian capital Tallinn. The sun is shining, the weather is beautiful, and overall it’s a perfect late summer/early fall kind of day to enjoy. But we will spend our time here today inside the walls of the beautiful Hilton Park Hotel and Olympic Casino to give you the latest happenings from the tournament area and the €1,100 No Limit Hold’em event which starts here at 2 p.m. local time. 

Players will start this two-day event with 30,000 in chips with blinds increasing every 30 minutes. Players can re-enter until their hearts are content until late registration is closed after Level 10. The plan for today is to play down to a final table of nine players and we will be with you on the floor the entire way.

The players are queuing up outside the casino entrance to register for this event as we speak and we’ll be back as soon as the cards are in the air with some actions from the tables, exciting names in the field, and other fun stuff. Stay tuned! 

11:30 (UTC+0)
Day 1A of WSOPC Tallinn Started
Level:      Blinds: 0/0     Ante: 0
Your search results are valid for . More Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.