select title_infopage as Infopage, count(distinct id_ligne) as "Nombre d'affichages" from VUE(), infopages where Infopage like '%/opac/index.php?lvl=infopages&pagesid=%' and id_infopage=substring_index(Infopage,'pagesid=',-1) group by 1