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

1. plats chauds uniques
2. moussaka