Nos marques
Requête 1 invalideselect p.marque,m.description,p.cdessfamille,count(*) as nbprod from optionprod as o,produit as p left join marque as m on p.marque=m.marque where
o.numprod=p.numprod and p.publie=1 and p.archive=0 and left(p.marque,1) in () group by p.marque order by p.marque