Query Run
SET @minus_7 = DATE_FORMAT(NOW() - INTERVAL 7 DAY, '%Y%m%d%H%i%s'); SET... 1 year ago
SET @minus_7 = DATE_FORMAT(NOW() - INTERVAL 7 DAY, '%Y%m%d%H%i%s'); SET... 1 year ago