select * from products where base='PRODUITS' and categorie='patisserie-salee' and scat1='gnoochi' AND inactif = false order by refnum1

1. patisserie salée
2. gnoochi