SELECT periodes.id, periodes.nom, participations.participant_id
FROM periodes
LEFT JOIN participations ON periodes.id = participations.periode_id
SELECT periodes.id, periodes.nom, participations.participant_id
FROM periodes
LEFT JOIN participations ON periodes.id = participations.periode_id