Prestashop: [BO IMPROVEMENT] CMS page views count

[PrestaShark]

Hi.
In some cases store owners use native CMS pages and categories for "Blog" purposes.
Would be nice to add CMS page views count to them.

Thanks!

[khouloudbelguith]

Hi @PrestaShark,

Thanks for your report.
We can use this sql query to count views of CMS-pages

   c.id_cms as pageID,
   cl.link_rewrite as CMSName,
   SUM(pv.counter) AS total 
FROM ps_page_viewed pv
LEFT JOIN ps_date_range dr ON pv.id_date_range = dr.id_date_range
LEFT JOIN ps_cms c ON pv.id_page = c.id_cms 
LEFT JOIN ps_cms_lang cl ON c.id_cms = cl.id_cms
 WHERE  cl.id_lang=1
GROUP BY pv.id_page
ORDER BY pageID

as described in this forum.
Ping @marionf, @colinegin what do you think of this improvement.

Thanks!

[PrestaShark]

Undefined error "checkedForm" upon query save.
Clean 1.7.5.2

[khouloudbelguith]

@PrestaShark, fixed in the PS1.7.6.0
https://drive.google.com/file/d/1w2MWC_826iAkb6lkNxmVC1WgqWkKJLe6/view
Thanks!

[PrestaShark]

@khouloudbelguith thanks for info! Still waiting for final 1.7.6 release :)