Trending

WordPress-Datenbank-Fehler: [Unknown column 'v.last_viewed' in 'where clause']
SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid', SUM(v.pageviews) AS 'pageviews' FROM df_popularpostssummary v LEFT JOIN df_posts p ON v.postid = p.ID WHERE 1 = 1 AND p.post_type = 'post' AND v.last_viewed > DATE_SUB('2018-06-18 05:28:52', INTERVAL 1 DAY) AND p.post_password = '' AND p.post_status = 'publish' GROUP BY v.postid ORDER BY pageviews DESC LIMIT 10;