Requête 1

Requête utilisée :

SELECT DISTINCT I.*
FROM `Intervenant` AS I, `ActeurDOeuvre` AS AO
WHERE I.`IntervenantId` = AO.`IntervenantId`
    AND EXISTS ( SELECT O.`OeuvreId`
             FROM `Oeuvre` AS O
             WHERE O.`OeuvreId` = AO.`OeuvreId`
                 AND O.`AnneeCreation` = 2003 )
AND AO.`IntervenantId` IN
( SELECT DISTINCT AO.`IntervenantId`
  FROM `ActeurDOeuvre` AS AO
  WHERE EXISTS ( SELECT O.`OeuvreId`
                 FROM `Oeuvre` AS O
                 WHERE O.`OeuvreId` = AO.`OeuvreId`
                     AND O.`AnneeCreation` = 2004 )
  AND AO.`IntervenantId` IN
  ( SELECT DISTINCT AO.`IntervenantId`
    FROM `ActeurDOeuvre` AS AO
    WHERE EXISTS ( SELECT O.`OeuvreId`
                   FROM `Oeuvre` AS O
                   WHERE O.`OeuvreId` = AO.`OeuvreId`
                       AND O.`AnneeCreation` = 2005 )
    AND AO.`IntervenantId` IN
    ( SELECT DISTINCT AO.`IntervenantId`
      FROM `ActeurDOeuvre` AS AO
      WHERE EXISTS ( SELECT O.`OeuvreId`
                     FROM `Oeuvre` AS O
                     WHERE O.`OeuvreId` = AO.`OeuvreId`
                         AND O.`AnneeCreation` = 2006 )
      AND AO.`IntervenantId` IN
      ( SELECT DISTINCT AO.`IntervenantId`
        FROM `ActeurDOeuvre` AS AO
        WHERE EXISTS ( SELECT O.`OeuvreId`
                       FROM `Oeuvre` AS O
                       WHERE O.`OeuvreId` = AO.`OeuvreId`
                           AND O.`AnneeCreation` = 2007 )))))
LIMIT 30 OFFSET 0;