SELECT DISTINCT division.div_code,div_shortname
FROM add_info
LEFT JOIN status_subject ON add_info.subject_id=status_subject.subject_id
LEFT JOIN division ON status_subject.div_code=division.div_code
Where division.div_code!=1 AND add_info.info_status!='2' AND status_subject.subject_id in ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','76')
Order BY add_info.info_update DESC