SELECT u.ProjectID, wo.Job_Name, COUNT(u.ProjectID) AS ctWOID FROM `Uploads` AS u
LEFT JOIN Work_Orders AS wo ON wo.ID = u.ProjectID
WHERE u.CustomerID = 3001 AND u.Upload_Date_Time > '2017-05-01 00:00:00' AND wo.Work_Type = 1
GROUP BY u.ProjectID
ORDER BY ctWOID ASC