select *
from `article`,`gammes`
where `article`.`Divers1` = gammes.code_sage
and gammes.id_famille=5
and gammes.id_parent=164
and gammes.id=167
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
Aluminium
<--
