SELECT g.S_STUDENT_GROUP,g.S_DOC,dt.folder_name
FROM last_EDUCONTENT_DOC_GROUP g
INNER JOIN last_educontent_doc doc ON g.s_doc=doc.id
INNER JOIN last_educontent_doc_type dt ON doc.s_doc_type=dt.id
LEFT OUTER JOIN temp_ecfiles f ON f.path='/var/www/portal/upload/educontent/'||dt.folder_name||'/'||doc.file_name
WHERE f.path IS NULL AND dt.folder_name NOT IN('fgos','oop','rp','tkzv')