SELECT album.titel AS album_titel,
album.titel_key AS album_key,
album.id AS album_id,
album.tekst AS album_tekst,
album.datum AS album_datum,
fotos.*
FROM fotos
LEFT JOIN album ON fotos.record_id = album.id
WHERE fotos.online = 1
AND album.online = 1 AND album.id = 16 ORDER BY fotos.pos ASC
Ontbijtsessie Met Marc Lammers - Foto's - WTC Schiphol Business Club