select * from products where base='PRODUITS' and categorie='plats-chauds-uniques' and scat1='choucroute-garnie' AND inactif = false order by refnum1

1. plats chauds uniques
2. choucroute garnie