SELECT *
FROM (`categorie`)
WHERE `id_cat` =  '47'
AND `afficher` =  '1'