SELECT
photos.id,
'photo' AS media_type,
photos.titre AS title,
photos.episode AS episode,
photos.typephoto AS category,
photos.fichier AS file
FROM photos WHERE id_objet ='6508' AND table_page ='films' AND date_ajout = '2021/12/12' AND photos.adulte <> '1' LIMIT 100
SELECT
photos.id,
'photo' AS media_type,
photos.titre AS title,
photos.episode AS episode,
photos.typephoto AS category,
photos.fichier AS file
FROM photos WHERE id_objet ='6508' AND table_page ='films' AND date_ajout = '2021/12/11' AND photos.adulte <> '1' LIMIT 100
SELECT
photos.id,
'photo' AS media_type,
photos.titre AS title,
photos.episode AS episode,
photos.typephoto AS category,
photos.fichier AS file
FROM photos WHERE id_objet ='6508' AND table_page ='films' AND date_ajout = '2021/12/10' AND photos.adulte <> '1' LIMIT 100
SELECT
photos.id,
'photo' AS media_type,
photos.titre AS title,
photos.episode AS episode,
photos.typephoto AS category,
photos.fichier AS file
FROM photos WHERE id_objet ='6508' AND table_page ='films' AND date_ajout = '2021/12/07' AND photos.adulte <> '1' LIMIT 100
SELECT
photos.id,
'photo' AS media_type,
photos.titre AS title,
photos.episode AS episode,
photos.typephoto AS category,
photos.fichier AS file
FROM photos WHERE id_objet ='6508' AND table_page ='films' AND date_ajout = '2021/12/04' AND photos.adulte <> '1' LIMIT 100
SELECT
photos.id,
'photo' AS media_type,
photos.titre AS title,
photos.episode AS episode,
photos.typephoto AS category,
photos.fichier AS file
FROM photos WHERE id_objet ='6508' AND table_page ='films' AND date_ajout = '2021/12/03' AND photos.adulte <> '1' LIMIT 100
SELECT
photos.id,
'photo' AS media_type,
photos.titre AS title,
photos.episode AS episode,
photos.typephoto AS category,
photos.fichier AS file
FROM photos WHERE id_objet ='6508' AND table_page ='films' AND date_ajout = '2021/11/28' AND photos.adulte <> '1' LIMIT 100