0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0079 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-12-23' AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/33/125/updates' ORDER BY `views` DESC

0.0153 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-12-23' AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/33/125/updates'

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

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

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

0.0334 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0057 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '125' AND `published` = 1

0.0281 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0054 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '129' AND `published` = 1

0.0305 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0061 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '130' AND `published` = 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0054 SECONDS:
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name` FROM `tour_stop_blog_day_posts` LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id` WHERE `tour_stop_blog_day_id` = '125' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Translate
WSOPC Tallinn Event #6: €1,500 WSOPC Tallinn Main Event Live Reporting - Day 4
1 New Update - Click to refresh
Live Updates - Day 1B
Urmo Velvelt Continues Heater; Bags Overall Chip Lead on Day 1b Posted Wednesday 20th September, 2023 at 19:31(UTC+0) by Jason Glatzer

Estonia's Urmo Velvelt (pictured above) recently finished in third place in the Kings of Tallinn Summer Showdown €1,100 Main Event for his largest live poker tournament cash of €49,300 and is in a position to potentially break his personal record thanks to bagging the overall chip lead of 293,000 on Day 1b in the 2023 World Series of Poker Circuit (WSOPC) Tallinn €1,500 Main Event.

Most of Velvelt's chips came in a glorious fashion as he won a massive flip for a 200,000 pot when his sevens turned into quads on the flop to eliminate Lithuania's Vasilj Barna who was in the rare position of drawing dead with two cards to come with big slick.

Today was special, but Velvelt had a heck of a day yesterday as well as he won the big bounty of €10,000 in Event #6: €660 No-Limit Hold'em Mystery Bounty. His total haul was €20,560 including the €4,060 he won for finishing in fourth place. This was more than what the ring winner Ranno Sootla claimed as he won the €10,000 top prize along with €5,000 in bounties.

Velvelt not only topped the 42 players bagging chips on Day 1b out of the total field of 107 entries, but he also bested Day 1a chip leader Joni Rantamaki from Finland who parlayed his 50,000 opening stack into 272,000 to lead the 63 survivors out of the 139 entries in the field.

This brings the field already up to 246 entries with 105 players advancing with the two biggest opening flights to go tomorrow with Day 1c kicking off at noon and Day 1d commencing at 7 p.m. Players will also be allowed to re-enter or late-register during the first two blind levels of Friday's Day 2. 

The Finnish duo of Juho Suutari (251,500) and Roope Tarmi (233,500) finished just behind Velvelt on Day 1b with Estonia's Raivo Pinsel (231,500) and Finland's Touko Berndtson (219,000) rounding out the top five.

Kare Hallamaa (218,500), Georgios Skarparis (210,500), Georgios Tsouloftas (207,000), and Jon Ander Martinez (205,000) were the other players on Day 1b to end with at least 200,000 in chips.

We will be back with more Main Event coverage for Day 1c at noon tomorrow. In the meantime, our live reporting team will provide plenty of updates in Event #8: €1,100 PLO 4 & 5 Cards, so be sure to check it out.

Final Day 1b Chip Counts Posted Wednesday 20th September, 2023 at 18:51(UTC+0) by Jason Glatzer
Player Country Chips Big Blinds
Urmo Velvelt Estonia 293,000 117
Juho Suutari Finland 251,500 101
Roope Tarmi Finland 233,500 93
Raivo Pinsel Estonia 231,500 93
Touko Berndtson Finland 219,000 88
Kare Hallamaa Finland 218,500 87
Georgios Skarparis Cyprus 210,500 84
Georgios Tsouloftas Cyprus 207,000 83
Jon Ander Martinez Spain 205,500 82
Adria Comas I Roura Spain 181,500 73
Kyosti Isberg Finland 180,500 72
Ruslan Stserbjuk Estonia 169,500 68
Nedas Nanys Lithuania 164,000 66
Josep Pastor De Ramon Spain 162,000 65
Vygerdas Jonikas Lithuania 147,000 59
Szymon Bujok Poland 143,000 57
David Spysschaert Belgium 141,000 56
Arthur Boatman USA 128,000 51
Andrey Koks Estonia 127,000 51
Andzej Zinkevic Lithuania 125,000 50
Johan Martinsen Finland 117,000 47
Kelly Kellner Canada 113,500 45
Mauri Dorbek Estonia 109,500 44
Martin Sedlak Germany 109,000 44
Ronny Albrigtsen Norway 103,000 41
Vadims Milovs Latvia 102,000 41
Morten Bremseth Norway 100,000 40
Gert Laanemets Estonia 91,000 36
Risto Parnat Finland 86,000 34
Stanislovas Norkus Lithuania 81,500 33
Samuli Hietala Finland 80,000 32
Ori Hasson Israel 71,500 29
Kert Hallik Estonia 70,000 28
Aleksandr Jelpidiforov Estonia 65,000 26
Alius Riskevicius Lithuania 60,000 24
Jevgenijs Sapronenko Latvia 56,000 22
Stefan Bittger Germany 41,000 16
Keito Kaljulaid Estonia 40,500 16
Steponas Venckus Lithuania 34,000 14
Johan Alen Finland 33,500 13
Topi Palenius Finland 20,500 8
Steven Seller Estonia 17,500 7
Players Bagging Chips Posted Wednesday 20th September, 2023 at 17:46(UTC+0) by Jason Glatzer

Players have begun to bag chips at many of the tables with the final hand or two taking place at some of the slower ones. 

We will update shortly with the final chip counts of Day 1b along with a short recap of the day. Stay tuned and in the meantime, check out our coverage of Event #8: €1,100 Pot-Limit Omaha.

Final Three Hands Posted Wednesday 20th September, 2023 at 17:40(UTC+0) by Jason Glatzer

The floor announced the final three hands for Day 1b.

Suutari Bluff-Catches Amat Posted Wednesday 20th September, 2023 at 17:38(UTC+0) by Jason Glatzer

Level 10: 1000/2,000 (2,000)
Entries: 44/108

The relentless aggression by Victor Amat didn't work in a hand against Juho Suutari. Suutari called a three bet preflop before calling bets on the flop, turn, and river leading up to a massive pot with the on the board.

Suutari called down the entire way and won a massive pot while also sending Amat to the rail when his proved to be good against .

Player Chips Progress
Juho Suutari 210,000 110,000
Victor Amat 0 0
Pinsel Rivers Wheel to Win Big Pot Posted Wednesday 20th September, 2023 at 17:38(UTC+0) by Alaxandar Georgiev

Level 10: 1000/2,000 (2,000)
Entries: 45/108

A big pot was played between Raivo Pinsel and Estonia's Vladislav Topilskiy. With both players re-raising each other on the flop Topilskiy called the final all-in for his remaining 90,000 chips.

Raivo Pinsel:
Vladislav Topilskiy:

Topilskiy was ahead, but he had to fade a lot of cards, the turn was good for him but he needed to fade the river as any heart would complete a flush for his opponent while a four would be equally damaging for Topliskiy as Pinsel would improve to a wheel.

The river wasn't a heart and Topilskiy began some early celebrations. However, his celebration was cut short after realizing he was out of chips since the four also completed a wheel for Pinsel.

Player Chips Progress
Raivo Pinsel 255,000 205,000
Vladislav Topilskiy 0 0
17:08 (UTC+0)
Start of Level 10
Blinds: 1,000/2,000     Ante: 2,000
The Kicker Is Good Posted Wednesday 20th September, 2023 at 17:08(UTC+0) by Alaxandar Georgiev

Level 9: 1000/1,500 (1,500)
Entries: 57/108

Mairo Tori Opened from the pot and was three-bet by Jon Ander from the button, Tori called and the action went to the flop.

The flop was on which Tori check-called a small bet from Ander. The same thing happened on the turn and all the chips went in from Ander on the river and Tori called.

Mairo Tori:
Jon Ander:

Ander scooped a pot for more than 140,00 chips with the better kicker.

Player Chips Progress
Jon Ander Martinez 230,000 60,000
Mairo Tori 0 0
Bujok Heads to Broadway Posted Wednesday 20th September, 2023 at 16:51(UTC+0) by Jason Glatzer

Level 9: 1,000/1,500 (1,500)
Entries: 59/107

Roberts Rumba jammed for about 10 big blinds from the hijack before Szymon Bujok three-bet shoved for 67,000 from the big blind.

The action paused on Urmo Velvelt from the big blind. 

"Not sure," Velvelt said. "I have nines."

The dealer asked Velvelt to not speak as it wasn't a classic all-in situation and you aren't allowed to engage with others at the table when there are two players with their stacks committed.

Velvelt understood and tanked a little more before laying down his hand.

"Did you really have nines?" Bujok said before the cards were turned over. "I have tens."

"Lucky me," Velvelt said with a big smile.

Roberts Rumba:
Szymon Bujok:

Rumba's ace found a partner on the board and momentarily thought he won the hand before quickly realizing he was out of chips with this board also improving Bujok off tens and into Broadway.

Player Chips Progress
Szymon Bujok 85,000 35,000
Roberts Rumba 0 0
Jacks for Parnat Posted Wednesday 20th September, 2023 at 16:49(UTC+0) by Alaxandar Georgiev

Level 9: 1000/1,500 (1,500)
Entries: 61/108

Risto Parnat raised under the gun for 4,000. Ori Hasson called from the button and Tarmo Tammel did the same from the big blind.

Parnat bet 4,500 on the  flop. Hasson raised to 13,500. Tammel folded and Parnat called.

The  on the turn was checked by Parnat and Hasson quickly bet 15,000 chips. Parnat quickly called.

The river went check-check. Parnat opened to win the hand after Hasson mucked. 

Player Chips Progress
Risto Parnat 100,000 50,000
Ori Hasson 90,000 100,000
At Least 25 Seats to the Main Event Guaranteed Tonight! Posted Wednesday 20th September, 2023 at 16:38(UTC+0) by Jason Glatzer

For those of you looking at the schedule, you likely noticed a €150 Mega Satellite guaranteeing 10 seats to the WSOPC Tallinn €1,500 Main Event at 9 p.m.

What you wouldn't have seen is a new satellite that popped up with some tremendous value for late-night players as at Midnight there will be an added €150 mega satellite with another 15 seats guaranteed! 

Of course, Omaha lovers will still be able to enjoy Event #36: €150 PLO 4, 5, & 6 card event at 11 p.m.. This is a six-max affair, which makes perfect sense once incorporating the six-card Omaha.

16:33 (UTC+0)
Start of Level 9
Blinds: 1,000/1,500     Ante: 1,500
Various Big Stacks at Break Posted Wednesday 20th September, 2023 at 16:20(UTC+0) by Jason Glatzer
Player Chips Progress
Georgios Tsouloftas 230,000 130,000
Urmo Velvelt 195,000 5,000
Ori Hasson 190,000 5,000
Semjons Karuckis 180,000 50,000
Jon Martinez 170,000 120,000
Vygerdas Jonikas 170,000 120,000
David Spysschaert 170,000 110,000
Josep Pastor De Ramon 160,000 110,000
Final Break Posted Wednesday 20th September, 2023 at 16:08(UTC+0) by Jason Glatzer

Players are on their final 20-minute break and will play two more levels when the action resumes before bagging up for Day 1b.

Velvelt Doubles After Flopping Quads Posted Wednesday 20th September, 2023 at 15:49(UTC+0) by Jason Glatzer

Level 8: 600/1,200 (1,200)
Entries: 65/108

A raising war resulting in a pot of nearly 200,000 between Urmo Velvelt (pictured below) and Vasilij Barna with Velvelt four-bet jammed and Barna, who was slightly covered, quickly calling.

Vasilij Barna:
Urmo Velvelt:

The flip was on but the table quickly erupted as Velvelt spiked not a set but quads on the flop. Barna, who was already drawing dead, took out his phone to snap photos with a smile in disbelief before eventually gathering his belongings after the turn and river completed the board.

Player Chips Progress
Urmo Velvelt 200,000 150,000
Vasilij Barna 0 0
Koks Doubles Through Bremseth Posted Wednesday 20th September, 2023 at 15:38(UTC+0) by Jason Glatzer

Level 8: 600/1,200 (1,200)
Entries: 68/105

Adria Comas I Roura opened for 2,500 from the button before Morten Bremseth three-bet to 8,600 from the small blind. The action paused for a couple of minutes on Andrey Koks (pictured below), who eventually cold called while Comas I Roura folded.

Bremseth continued for 6,500 on the . Koks jammed for 36,200 and Bremseth called with Koks at risk.

Andrey Koks:
Morton Bremseth:

Koks was miles ahead with his set against Bremseth's top pair and had his opponent drawing dead on the turn. The river completed the action and Koks doubled through Bremseth with a full house.

Player Chips Progress
Andrey Koks 90,000 72,000
Morten Bremseth 40,000 10,000
15:26 (UTC+0)
Start of Level 8
Blinds: 600/1,200     Ante: 1,200
Set of Fives for Hasson Posted Wednesday 20th September, 2023 at 15:11(UTC+0) by Jason Glatzer

Level 7: 500/1,000 (1,000)
Entries: 74/104

Pavel Solodovnikov check-raised the turn with close to 20,000 in the pot already from 10,500 to 23,500. Ori Hasson tanked for a minute before he called.

Solodovnikov bet 25,000 on the river and Hasson called. Solodovnikov turned over the to win the hand against his opponent's .

Although Solodovnikov did have around 20,000 after the hand, this didn't last long as a couple of hands later he was noticed leaving the tournament arena.

Player Chips Progress
Ori Hasson 185,000 95,000
Pavel Solodovnikov 0 0
Big Slick No Good for Mika Posted Wednesday 20th September, 2023 at 15:07(UTC+0) by Jason Glatzer

Level 7: 500/1,000 (1,000)
Entries: 78/104

Ramunas Mika called off his stack of less than 15 big blinds after David Spysschaert three-bet jammed from the big blind.

Ramunas Mika:
David Spysschaert:

Spysschaert connected with his ten on the runout to send Mika to the rail.

Player Chips Progress
David Spysschaert 60,000 10,000
Dmitri Dudakov 0 0
Ramunas Mika 0 0
14:47 (UTC+0)
Start of Level 7
Blinds: 500/1,000     Ante: 1,000
Big Stacks Update Posted Wednesday 20th September, 2023 at 14:43(UTC+0) by Alaxandar Georgiev

Check some of the bigger stacks we have on Day 1b below.

Player Chips Progress
Mauri Dorbek 160,000 110,000
Kelly Kellner 130,000 3,000
Semjons Karuckis 130,000 10,000
Georgios Skarparis 125,000 75,000
Juho Suutari 100,000 50,000
Nedas Nanys 93,000 43,000
Ori Hasson 90,000 40,000
Second Break Posted Wednesday 20th September, 2023 at 14:28(UTC+0) by Jason Glatzer

Players are on their second break of the day. Big stack will be updated in the blog at the break.

Mis-Click Elimination Posted Wednesday 20th September, 2023 at 14:16(UTC+0) by Alaxandar Georgiev

Julian Selinger thought he opened to 1,700 and Mustafa Biz called from the lojack, shortly after the dealer saw that he put 15,200 instead and the raise was valid, so Mustafa had to decide if he wanted to call that or not and he made the call.

To the flop it was Selinger's decision and he put another 15,000 followed by a call by Mustafa.

Julian Selinger:
Biz Mustafa:

The turn was and the river changed nothing for Mustafa.

Selinger won over 25,000 chips by "miss-clicking" his way to victory.

Player Chips Progress
Julian Selinger 65,000 15,000
Mustafa Biz 0 0
100 Entries! Posted Wednesday 20th September, 2023 at 14:10(UTC+0) by Jason Glatzer

Level 6: 400/800 (800)
Entries: 86/100

Day 1b has reached 100 entries during Level 6. This is still a little shy of the 139 entries Day 1a ended with still more than four levels remaining in Day 1b.

14:02 (UTC+0)
Start of Level 6
Blinds: 400/800     Ante: 800
One Outer for Nurme Posted Wednesday 20th September, 2023 at 13:38(UTC+0) by Jason Glatzer

Level 5: 300/600 (600)
Entries: 84/94

There was 50,000 in the pot including the entire stack of 25,000 held by Toomas Nurme committed on the flop in a hand against Ronny Albrigtsen.

Toomas Nurme:
Ronny Albrigtsen:

Albrigtsen pulled far ahead after improving to trips on the turn leaving his opponent to just one out. The one outer came with the case spiking the river for Nurme to double his stack instead of hitting the rail.

Player Chips Progress
Toomas Nurme 50,000 10,000
Ronny Albrigtsen 50,000 26,500
No "One-Time" for Koks Against Albrigtsen Posted Wednesday 20th September, 2023 at 13:30(UTC+0) by Jason Glatzer

Level 5: 300/600 (600)
Entries: 85/94

There was already 20,000 in the pot when Andrey Koks checked with the on the board. Ronny Albrigtsen bet 6,000. Koks tanked before he called.

"One time, one time," Koks pleaded.

Koks let out a loud sigh after the completed the board on the river and checked. Albrigtsen checked it back and won the hand after showing .

"You had a five?" Albrigtsen asked?

Koks shared he did but we will never know if that was the case as his cards went into the muck.

Player Chips Progress
Ronny Albrigtsen 76,500 26,500
Andrey Koks 18,000 42,000
13:03 (UTC+0)
Start of Level 5
Blinds: 300/600     Ante: 600
Kings Full Good for Tousloftas Posted Wednesday 20th September, 2023 at 13:01(UTC+0) by Jason Glatzer

Level 4: 200/500 (500)
Entries: 82/89

The second Day 1b bullet for Georgios Tsouloftas (pictured below) has gone far better than the first bullet as he has around double the starting stack during Level 4.

Kare Hallamaa fired out for 4,200 into a pot of a bit more with the on the board. Tousloftas tanked for a short time before raising to 15,000. Hallamaa quickly called only to muck after Tousloftas turned over the to win the hand.

Player Chips Progress
Georgios Tsouloftas 100,000 55,000
Ronny Albrigtsen 50,000 0
Martin Lategui 50,000 0
Martin Piik 40,000 10,000
Kare Hallamaa 30,000 20,000
Two Pair for Martinsen Posted Wednesday 20th September, 2023 at 12:46(UTC+0) by Jason Glatzer

Level 4: 200/500 (500)
Entries: 78/85

Johan Martinsen (pictured below) checked with nearly 15,000 in the pot and the on the board. Victor Fernandez Garcia tanked for a couple of minutes before he bet 10,000.

Martinsen snap-called. Garcia turned over the which proved to be no match for the two-pair by Martinsen with .

Player Chips Progress
Johan Martinsen 75,000 25,000
Victor Fernandez Garcia 65,000 15,000
12:22 (UTC+0)
Start of Level 4
Blinds: 200/500     Ante: 500
First Break Posted Wednesday 20th September, 2023 at 12:03(UTC+0) by Jason Glatzer

Players are on their first 20-minute break. Blinds will increase to 200/500 with a 500 big blind ante when the action resumes.

Karuckis Ousts Two to Take Early Day 1b Chip Lead Posted Wednesday 20th September, 2023 at 12:03(UTC+0) by Jason Glatzer

Level 3: 200/400 (400)
Entries: 70/76

Semjons Karuckis just won a couple of flips to take the chip lead off a sub-starting stack for nearly triple the starting stack.

The first flip came after he four-bet jammed with and was called by Rene Peterkopf with . The flop was looking good for Peterkopf but he wasn't able to come back after falling behind on the turn with the river completing the board.

Shortly after, Karuckis with took the 8,500 remaining in his stack held by Peterkopf with along with a bigger stack held by Vladimiras Meckovskis with . Both of Karuckis's opponents bricked board to send them packing while snagging the early Day 1b chip lead.

Meanwhile, Kelly Kellner also built up his stack further. He shared with us he flopped a set of jacks on a with two diamonds with the turn put a third diamond on the board. The stacks went in on the turn and his opponent turned over the with no diamond. No ten came on the river and Keller was up to 127,000 after the hand.

Player Chips Progress
Semjons Karuckis 140,000 90,000
Kelly Kellner 127,000 57,000
Vladimiras Meckovskis 0 0
Rene Peterkopf 0 0
Video Recap From Day 6 Posted Wednesday 20th September, 2023 at 11:53(UTC+0) by Jason Glatzer

Trips for Rasanen Posted Wednesday 20th September, 2023 at 11:43(UTC+0) by Jason Glatzer

Level 3: 200/400 (400)
Entries: 68/70

Two players checked before Georgios Tsouloftas, who re-entered after hitting the rail during Level 2, bet 1,500 into a pot of a bit more with the on the flop. Tomi Rasanen, Pavel Solodovnikov, and Dmitri Dudakov all called.

The action slowed down the rest of the way with all four players checking down the turn and the river.

Solodovnikov turned over the which led Dudakov and Tsouloftas to muck their cards. Meanwhile, Rasanen had something up his sleeve and turned over the for trip fours to scoop the pot.

Player Chips Progress
Tomi Rasanen 65,000 15,000
Dmitri Dudakov 60,000 10,000
Pavel Solodovnikov 50,000 0
Georgios Tsouloftas 45,000 5,000
11:27 (UTC+0)
Start of Level 3
Blinds: 200/400     Ante: 400
Arnhold Eliminates First Player of the Day in Tsouloftas Posted Wednesday 20th September, 2023 at 11:16(UTC+0) by Jason Glatzer

Level 2: 100/300 (300)
Entries: 61/63

Cyprus's Georgios Tsouloftas was the first player on the rail for Day 1b.

Tsouloftas check-raised a bet of 2,300 into a pot of a bit more by Henry Arnhold to 10,000 with the on the board after the turn and Arnhold called to see the river.

Tsouloftas bet 15,000 and Arnhold went into the tank for nearly a minute before he opted to jam over the top more than covering the around 25,000 or so his opponent had behind. A few minutes went by before Tsouloftas tossed a chip in to call.

Arnhold immediately turned over the nuts with for a straight and eliminated Tsouloftas who still has plenty of time to re-enter who was good until the river with a set with .

Player Chips Progress
Henry Arnhold 100,000 50,000
Mustafa Biz 0 0
Georgios Tsouloftas 0 0
Nut Flush for Kellner Posted Wednesday 20th September, 2023 at 10:59(UTC+0) by Jason Glatzer

Level 2: 100/300 (300)
Entries: 54/54

While none of the Day 1b players has yet to hit the rail, Canada's Kelly Kellner has managed to chip up to 70,000 in chips.

Kellner shared that he had in a hand against Priit Parmasto. There were two diamonds on the flop and four on the board with more diamonds coming on the turn and river. Parmasto fired out for 10,000.

A rainbow raise, that Kellner is known for, meaning one chip of each color representing a raise to 31,600. Parmasto opted to fold and good for him he did as Kellner showed the table he had the goods by flashing the before the next hand began.

WSOPC Tallinn Host Evely Pihela interviewed Kellner earlier in the week. Check out the interview below:

Player Chips Progress
Kelly Kellner 70,000 20,000
Priit Parmasto 35,000 15,000
10:50 (UTC+0)
Start of Level 2
Blinds: 100/300     Ante: 300
"I Really Want to Raise..." Posted Wednesday 20th September, 2023 at 10:37(UTC+0) by Jason Glatzer

Level 1: 100/200 (200)
Entries: 44/44

Toomas Nurme bet 800 into a spread pot of 100 chips of around 2,000 with the on the board after the turn. Andrey Koks raised to 2,000 and Nurme opted to call to see the river.

Nurme fired out for 4,200 and Koks tanked for about a minute before eventually attempting to begin a dialogue with Nurme.

"I really want to raise," Koks said. "But you might have fives or something."

Seconds later, Koks opted to just call and not raise.

Nurme turned over the for two pair.  Koks then showed his to win the hand with trip deuces.

Player Chips Progress
Andrey Koks 60,000 10,000
Toomas Nurme 40,000 10,000
Helppi in the PLO Ring Event Posted Wednesday 20th September, 2023 at 10:22(UTC+0) by Jason Glatzer

Level 1: 100/200 (200)
Entries: 39/39

Juha Helppi shared with the media last night that he planned to hop into Day 1b of the Main Event after losing his big stack on Day 1b thanks to bad beats and coolers to a pair of Estonian players.

Helppi was just spotted during the opening moments of Event #8: €1,100 Pot-Limit Omaha 4 & 5 Cards.

"I saw the PLO on the schedule and decided to hop into this instead," Helppi shared from the table. "I will get back into the Main Event tomorrow."

While we won't have the presence of Helppi today in the Main Event, many other players will get into the action. Below is a quick look at the early entries in the field.

Player Chips Progress
Kelly Kellner 50,000 0
Vilius Zabarauskas 50,000 0
Roberts Rumba 50,000 0
Vygerdas Jonikas 50,000 0
Priit Parmasto 50,000 0
Martin Sedlak 50,000 0
Raivo Pinsel 50,000 0
Steven Seller 50,000 0
Todd Jatras 50,000 0
Cards in the Air Posted Wednesday 20th September, 2023 at 10:06(UTC+0) by Jason Glatzer

Level 1: 100/200 (200)
Entries: 29/29

Day 1b of the Main Event kicked off after the preliminary announced by WSOPC Tallinn Tournament Director Teresa Nousiainen with 29 players in their seats when the first cards were dealt.

Best of luck to all of the Day 1b players.

Welcome to Day 1b of the WSOPC Tallinn Main Event Posted Wednesday 20th September, 2023 at 08:24(UTC+0) by Jason Glatzer

It is another big day for the inaugural World Series of Poker Circuit (WSOPC) Tallinn with the second of four opening flights of the 2023 WSOPC Tallinn €1,500 Main Event starting its action on Tuesday at noon. Not only will a player win a coveted WSOPC gold ring but also a lion's share of what promises to be a massive prize pool with a €1 million guarantee slapped on this event.

The four-day Main Event is a deep-stacked affair boasting four opening flights from Sept. 19-21 with players starting with 50,000 in opening chips. Blinds increase slowly at every 40 minutes during the first three opening flights with the final opening flight moving along a little quicker with 30-minute blind levels.

Players will have plenty of opportunities to accumulate chips with unlimited re-entries permitted throughout the four opening flights and during the first two blind levels of Day 2. The battle will continue on Sept. 22-24 until the first-ever WSOPC Tallinn Main Event winner is crowned.

We will see many big names, including Finnish poker legend and two-time WSOP bracelet winner Juha Helppi (pictured below), who built up a big stack yesterday only for bad beats and coolers to take it away, hunting for the Main Event gold ring awarded to the winner along with a healthy top prize and an invitation to a $1 million guaranteed 2023 WSOP Tournament of Champions freeroll where a WSOP bracelet is on the line.

Day 1a attracted 139 entries with 63 players advancing to Friday's Day 2. Finland's Joni Rantamaki currently sits on top of the leaderboard after bagging a Day 1a chip leading stack of 272,000.

Our coverage starts at noon with blinds at 100/200 and a 200 big blind ante. Follow the Main Event journey throughout the week while we report the biggest hands, bad beats, and stories until a winner is crowned.

08:19 (UTC+0)
Day 1B of WSOPC Tallinn Started
Level: 1     Blinds: 100/200     Ante: 200
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.