Query Run
-- start time SET @tim = DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -180 DAY),... 3 years ago
-- start time SET @tim = DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -30 DAY),... 3 years ago
-- start time SET @tim = DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -7 DAY),... 3 years ago
-- start time SET @tim = DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 DAY),... 3 years ago