Filtering contacts by department gives MySQL error

[RussH]

the below error is reported in Contacts when trying to filter by Department

`MySQL Query Failed: Unknown column 'company_department.department' in 'where clause'

SELECT SQL_CALC_FOUND_ROWS
contact.is_hot AS isHot,
contact.contact_id AS contactID,
contact.contact_id AS exportID,
contact.date_modified AS dateModifiedSort,
contact.date_created AS dateCreatedSort,
owner_user.first_name AS ownerFirstName,
owner_user.last_name AS ownerLastName,
CONCAT(owner_user.last_name, owner_user.first_name) AS ownerSort,
contact.first_name AS firstName,
contact.last_name AS lastName,
company.name AS name,company.company_id as companyID,
contact.title AS title,
contact.phone_work AS workPhone,
DATE_FORMAT(contact.date_created, '%d-%m-%y') AS dateCreated,
DATE_FORMAT(contact.date_modified, '%d-%m-%y') AS dateModified,
company_department.company_department_id AS companyDepartmentID, company_department.name as department
FROM
contact
LEFT JOIN company
ON contact.company_id = company.company_id
LEFT JOIN user AS owner_user
ON contact.owner = owner_user.user_id
LEFT JOIN company_department on company_department.company_department_id = contact.company_department_id LEFT JOIN saved_list_entry
ON saved_list_entry.data_item_type = 300
AND saved_list_entry.data_item_id = contact.contact_id
AND saved_list_entry.site_id = 1
WHERE
contact.site_id = 1
AND (company_department.department = 'HR' )

        GROUP BY contact.contact_id
        
        ORDER BY department DESC
        LIMIT 0, 15`