SELECT rand()as random, album.image_id, album.album_id, album.titre_fr, album.titre_de, album.photo, album.text_fr,
album.text_fr, album.mots_clefs_fr,album.mots_clefs_de, album.enregistre, album.lu_fr,album.lu_de,
files.name_on_server, users.username, users.user_id, users.email FROM album
LEFT JOIN files ON files.file_id=album.photo
LEFT JOIN users ON users.user_id=album.user_id WHERE album.supprime=0 AND (album.publier=1 OR album.publier=3) AND album.`type`='photo' ORDER BY enregistre desc,album.priorite desc,album.enregistre desc |
Forum 
