Query Run
SET @pmonthbegin=DATE_FORMAT(CURDATE() - INTERVAL 1 MONTH,'%Y%m01'), ... 1 year ago
SET @pmonthbegin=DATE_FORMAT(CURDATE() - INTERVAL 1 MONTH,'%Y%m01'), ... 1 year ago
SET @pmonthbegin=DATE_FORMAT(CURDATE() - INTERVAL 1 MONTH,'%Y%m01'), ... 1 year ago
SET @pmonthbegin=DATE_FORMAT(CURDATE() - INTERVAL 1 MONTH,'%Y%m01'), ... 1 year ago
SET @pmonthbegin=DATE_FORMAT(CURDATE() - INTERVAL 1 MONTH,'%Y-%m-01'), ... 1 year ago
SELECT page_title, user_name, COUNT(*) as Edits FROM page JOIN... 1 year ago