public static function deleteSpamComments()
{
$db = BackendModel::getContainer()->get('database');
// get ids
$itemIds = (array) $db->getColumn('SELECT i.post_id
FROM blog_comments AS i
WHERE status = ? AND i.language = ?', array('spam', BL::getWorkingLanguage()));
// update record
$db->delete('blog_comments', 'status = ? AND language = ?', array('spam', BL::getWorkingLanguage()));
// recalculate the comment count
if (!empty($itemIds)) {
self::reCalculateCommentCount($itemIds);
}
}