Metro

Wave

I-Wave

Block

                        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