WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%4$d, last_viewed = '%3$s'' at line 3]
INSERT INTO wp_popularpostsdata (postid, day, last_viewed, pageviews) VALUES (247863, '2017-10-18 22:24:07', '2017-10-18 22:24:07', 1) ON DUPLICATE KEY UPDATE pageviews = pageviews + %4$d, last_viewed = '%3$s';

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%2$d, last_viewed = '%4$s'' at line 3]
INSERT INTO wp_popularpostssummary (postid, pageviews, view_date, last_viewed) VALUES (247863, 1, '2017-10-18', '2017-10-18 22:24:07') ON DUPLICATE KEY UPDATE pageviews = pageviews + %2$d, last_viewed = '%4$s';

In defence of the Ptolemaic Model (sort of)