SELECT departments.department_name, ezr_projs.title AS ezr_projs_title, ezr_tasks.title AS ezr_tasks_title, ezr_tasks.id AS id_ezr_tasks, ezr_tasks.indate AS ezr_tasks_indate, ezr_tasks.outdate AS ezr_tasks_outdate, ezr_tasks.duedate AS ezr_tasks_duedate, ezr_tasks.done AS ezr_tasks_done
FROM ezr_tasks
INNER JOIN ezr_projs ON ezr_tasks.id_ezr_projs = ezr_projs.id
INNER JOIN ezr_task_types ON ezr_task_types.id = ezr_tasks.id_ezr_task_types
INNER JOIN ezr_task_shares ON ezr_task_shares.id_req_deps = ezr_projs.id_departments
INNER JOIN departments ON ezr_projs.id_departments = departments.id
WHERE ezr_task_shares.id_resp_deps
IN ( 11, 13 )
AND ezr_projs.outdate >= ezr_tasks.outdate
GROUP BY ezr_tasks.id
LIMIT 0 , 30