SELECT f.id AS photoId, fl.title AS photoTitle, fl.description AS photoDescription FROM content_data cd LEFT JOIN content_has_mma_file cf ON cf.content_data_id = cd.id AND cf.fileSet = 'pdf' LEFT JOIN mma_files f ON f.id = cf.mma_files_id LEFT JOIN mma_fileSizes fs ON fs.mma_files_id = cf.mma_files_id AND fs.fileSet = 'pdf' LEFT JOIN mma_filesLangData fl ON fl.mma_files_id = cf.mma_files_id AND fl.global_languages_code = 'slo' WHERE cd.content_structure_id = '13_slo' AND cd.publish_status = 'Y' AND cd.publicated = 'Y' ORDER BY cd.dataOrder
Sledite nam:
Facebook