SELECT A.* FROM department_specifications A
LEFT JOIN departments B ON B.department_id=A.department_id
LEFT JOIN department_submenu D ON D.submenu_id=A.submenu_id
WHERE B.division_id='36' AND B.department_id='30' AND A.dept_spec_type = 'T' AND B.department_status = 'Y' AND D.submenu_name = 'Placement'
