select case when page_subtype=101 then 'Recherche simple' when page_subtype=102 then 'Recherche multi-critères' when page_subtype=103 then 'Recherche par termes' when page_subtype=104 then 'Recherche externe' when page_subtype=105 then 'Recherche par tags' when page_subtype=106 then 'Recherche prédéfinie' when page_subtype=107 then "Recherche sur la page d'accueil" else page_subtype end as Recherche, count(id_ligne) as Nombre from VUE() where page_type='1' and page_subtype!='803' group by 1 order by 2 desc