WordPress database error: [Unknown column 'v.view_datetime' in 'where clause'] SELECT p.*
FROM wpuu_popularpostssummary v
LEFT JOIN wpuu_posts p ON v.postid = p.ID
WHERE 1 = 1 AND p.post_type = 'post'
AND v.view_datetime > DATE_SUB('2018-04-21 23:12:25', INTERVAL 1 MONTH)
AND p.post_status = 'publish' GROUP BY v.postid ORDER BY pageviews DESC LIMIT 5
WordPress database error: [Unknown column 'v.view_datetime' in 'where clause'] SELECT p.*
FROM wpuu_popularpostssummary v
LEFT JOIN wpuu_posts p ON v.postid = p.ID
WHERE 1 = 1 AND p.post_type = 'post'
AND v.view_datetime > DATE_SUB('2018-04-21 23:12:25', INTERVAL 1 WEEK)
AND p.post_status = 'publish' GROUP BY v.postid ORDER BY pageviews DESC LIMIT 5
WordPress database error: [Unknown column 'v.view_datetime' in 'where clause'] SELECT p.*
FROM wpuu_popularpostssummary v
LEFT JOIN wpuu_posts p ON v.postid = p.ID
WHERE 1 = 1 AND p.post_type = 'post'
AND v.view_datetime > DATE_SUB('2018-04-21 23:12:25', INTERVAL 1 Day)
AND p.post_status = 'publish' GROUP BY v.postid ORDER BY pageviews DESC LIMIT 5
Show Comments (0)