andrewhthomas
10/26/2012 - 4:09 PM

SPS - Projects to be backed up

SPS - Projects to be backed up

SELECT * FROM projects AS Project LEFT JOIN backups_projects ON Project.id = backups_projects.project_id INNER JOIN users AS User ON Project.user_id = User.id WHERE Project.date_end < CURDATE() - INTERVAL 90 DAY AND backups_projects.project_id IS NULL AND Project.backup_code IN ('', NULL) AND Project.active = 'No' ORDER BY Project.date_end DESC