Query Run
SET @oneyear = DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -365 DAY),... 6 days ago
SET @oneyear = DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -365 DAY),... 6 days ago