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

1. plats chauds uniques
2. choucroute de la mer