0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0076 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/33/125/updates'
ORDER BY `views` DESC
0.0663 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/33/125/updates'
0.0005 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.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '33'
0.0403 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0602 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '102'
AND `published` = 1
0.0374 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0723 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '125'
AND `published` = 1
0.2061 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0148 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '129'
AND `published` = 1
0.0798 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0047 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '130'
AND `published` = 1
0.0241 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0045 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '132'
AND `published` = 1
0.0650 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.0242 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0055 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '138'
AND `published` = 1
0.0057 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.0056 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.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` = '5457'
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` = '5452'
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` = '5444'
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` = '5442'
ORDER BY `chip_change` DESC, `busted` ASC
0.0155 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5432'
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` = '5430'
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` = '5425'
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` = '5423'
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` = '5420'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5416'
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` = '5415'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5407'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5398'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5391'
ORDER BY `chip_change` DESC, `busted` ASC
0.0159 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5383'
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` = '5380'
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` = '5379'
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` = '5375'
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` = '5374'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5368'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5361'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5357'
ORDER BY `chip_change` DESC, `busted` ASC
0.0086 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0267 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0122 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0129 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5340'
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` = '5339'
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` = '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.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` = '5331'
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` = '5328'
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` = '5327'
ORDER BY `chip_change` DESC, `busted` ASC
0.0374 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.0052 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.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` = '5457'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5444'
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` = '5442'
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` = '5440'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5432'
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` = '5430'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5425'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5418'
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` = '5416'
ORDER BY `chip_change` DESC, `busted` ASC
0.0181 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5402'
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` = '5398'
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` = '5396'
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` = '5391'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5380'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5375'
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` = '5374'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0175 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5361'
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` = '5358'
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` = '5357'
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` = '5355'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5351'
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` = '5347'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5339'
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` = '5336'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5331'
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` = '5328'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0171 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.0024 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2143
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
Many Thanks,
The MainEventTravel team
Translate
English
Deutsch
Français
Italiano
Español
Português
Čeština
Dansk
Polski
Română
Svenska
Norsk
Suomi
Eesti
Malti
עברית
العربية
Lietuvių
Български
Nederlands
Ελληνικά
Русский
WSOPC Tallinn
Event #6: €1,500 WSOPC Tallinn Main Event
Live Reporting - Day 4
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 .
Go to checkoutMore 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.
on the board.
proved to be good against 
.
flop Topilskiy called the final all-in for his remaining 90,000 chips.
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.
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.
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.
on the turn was checked by Parnat and Hasson quickly bet 15,000 chips. Parnat quickly called.
to win the hand after Hasson mucked. 
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 
river completed the board.
and the river 
flop in a hand against Ronny Albrigtsen.
completed the board on the river and checked. Albrigtsen checked it back and won the hand after showing 
which proved to be no match for the two-pair by Martinsen with 
turn with the 
with two diamonds with the 
for two pair. Koks then showed his 
