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 ph
LEFT JOIN projectfiles AS pf ON ph.id = pf.phase_id    AND pf.created >= DATE_SUB(CURDATE(),INTERVAL 1 DAY)
WHERE ph.phasetype = 'drawing'