Unnamed

SELECT distinct(ph.id) AS id, ph.created as phasecreated, pf.created as filecreated, ph.name AS name, ph.phasetype AS phasetype    FROM phases AS phLEFT JOIN projectfiles AS pf ON ph.id = pf.phase_id    AND pf.created >= DATE_SUB(CURDATE(),INTERVAL 1 DAY)WHERE ph.phasetype = 'drawing'