Trending Posts

Top views today

WordPress database error: [Unknown column 'last_viewed' in 'where clause']
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN ( SELECT postid, SUM( pageviews ) pageviews FROM wp_popularpostssummary WHERE last_viewed > DATE_SUB('2019-06-27 16:10:53', INTERVAL 1 DAY) GROUP BY postid) pvw ON wp_posts.id = pvw.postid WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled') ORDER BY pvw.pageviews DESC, wp_posts.post_date DESC LIMIT 0, 8

MENU

Back