select * from products where base='PRODUITS' and categorie='extrait-de-carte-de-noel-2022' and scat1='menu-a-27-50' AND inactif = false order by refnum1

1. extrait de carte de noël 2022
2. menu à 27,50€