phpcms新增文章点击排行排行页与最新文章列表页面
Author:zhoulujun Date:
phpcms 查看文章点击排行很简单,执行下面sql即可:
SELECT a.title , h.views,h.catid,a.id FROM v9_news AS a INNER JOIN v9_hits AS h ON CONCAT('c-1-', a.id) = h.hitsid ORDER BY h.views DESC LIMIT 20;
转载本站文章《phpcms新增文章点击排行排行页与最新文章列表页面》,
请注明出处:https://www.zhoulujun.cn/html/php/phpcms/2022_0608_8829.html