How to display popular article from multiple pages?
I try this code but didn't work
Could not successfully run query: Unknown column 'page_hits' in 'order clause'
I try this code but didn't work
- Code: Select all
<cms:query
sql="SELECT p.id, p.template_id
FROM <cms:php>echo K_TBL_PAGES;</cms:php> p
inner join <cms:php>echo K_TBL_TEMPLATES;</cms:php> t
on p.template_id = t.id
WHERE (t.name='car.php' or t.name='books.php' or t.name='news.php')
AND publish_date < '<cms:date format='Y-m-d H:i:s' />'
AND NOT publish_date = '0000-00-00 00:00:00'
ORDER BY publish_date desc;"
limit='10'
paginate='1'
fetch_pages='1'
orderby='page_hits'
>
Could not successfully run query: Unknown column 'page_hits' in 'order clause'