Patients Deactivated Past 12 Months

-- Patients deactivated in the past 12 months
SELECT
    p.LName,
    p.FName,
    sl.`LogDateTime`,
    sl.`LogText`,
    sl.`CompName`
FROM securitylog sl
INNER JOIN patient p ON sl.PatNum = p.PatNum
WHERE
    sl.LogText LIKE "Patient status changed from 'Patient' to%"
    AND DATE(sl.LogDateTime) >= CURDATE() - INTERVAL 12 MONTH  -- Limit results to previous 12 months
ORDER BY
    LogDateTime DESC
;