Requête 4

Requête utilisée :

SELECT *
FROM `Episode` AS E
WHERE NOT EXISTS
    ( SELECT *
    FROM `ActeurDEpisode` AS J2, `Intervenant` AS I
    WHERE I.`IntervenantId` = J2.`IntervenantId`
    AND J2.`OeuvreId` = E.`OeuvreId`
    AND J2.`Saison` = E.`Saison`
    AND J2.`Numero` = E.`Numero`
    AND I.`GenreActeur` = 'Acteur' )
LIMIT 30 OFFSET 0;