SELECT sections.*, photos1.fichier as photo1, photos2.fichier as photo2, photos3.fichier as photo3 FROM sections left join photos as photos1 on sections.IDphoto1=photos1.IDphoto left join photos as photos2 on sections.IDphoto2=photos2.IDphoto left join photos as photos3 on sections.IDphoto3=photos3.IDphoto WHERE sections.IDpage= ORDER BY sections.rang