Select idArt
From article
inner join artcarac on (article.idArt=artcarac.idxarticle)
inner join carac on(carac.idCarac=artcarac.idxcarac)
Where (annee='2012') and (couleur='gris')