SELECT *, SD_Serie_Ligne.idGammeArticle, SD_Serie_Ligne.ordre FROM vGRN_ARTICLE_GRN_ARTICLE_NON_STOCK a INNER JOIN SD_GammeArticle s ON a.arcod = s.RefArticle INNER JOIN SD_Serie_Ligne ON s.id = SD_Serie_Ligne.idGammeArticle where a.arutil='Non' and arcod=refarticle and s.societe='GROSSERON' and a.societe='GROSSERON' and gammeID=20854 AND s.id in( 5801493,5801495,5801497,5801499,5801501,5801503,5801505,5801507,5801509,5801511,5801513,5801515,5801517,5801519,5801521,5801523) AND exists (select * from SD_Serie where id = SD_Serie_Ligne.idSerie) ORDER BY SD_Serie_Ligne.Ordre