698Select id, staff_id, post_id, job_title_cy as 'job_title', dept_code, priority_job, is_telephone from profile_contracts_view WHERE profile_contracts_view.affiliated_role is null AND staff_id IN (SELECT staff_id from staff_profile3 WHERE email='srt') ORDER BY -priority_job DESC;