698Select id, staff_id, post_id, job_title_en 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='cob36') ORDER BY -priority_job DESC;