|
SELECT f.id_file, f.parent_file, f.id_site, f.file_type, f.name, f.modifieddate AS modifieddate, f.file_position FROM files f WHERE f.trash IS NULL AND f.file_workflow = 1 AND f.published = 1 AND ( f.id_site = 1 OR f.id_file IN ( SELECT files.id_file FROM file_share, files WHERE file_share.id_file = files.id_file AND file_share.id_site = 1 ) ) AND f.id_file NOT IN ( SELECT file_privileges.id_file FROM file_privileges, groups, user_groups WHERE file_privileges.id_group = groups.id_group AND groups.id_group = user_groups.id_group AND user_groups.id_user = 0 AND file_privileges.hidden_nav IS NOT NULL GROUP BY file_privileges.id_file ) AND f.file_type IN ('Articulo', 'Script') AND f.parent_file = 123 ORDER BY f.main_content DESC, f.creationdate DESC LIMIT 1 OFFSET 0
|
|
