select * from `article`,`gammes` where `article`.`Divers1` = gammes.code_sage and gammes.id_famille=5 and gammes.id_parent = '164' and gammes.code_sage<>'' and article.Sommeil ='0' and article.PrixBaseHT>0 and article.valide <>'non' order by article.ordre,Code asc LIMIT 0, 24 Raccords <--