SELECT workunits.ID
FROM workunits
LEFT JOIN workunitInputs ON workunits.ID = workunitInputs.workunitID
WHERE workunits.ID NOT IN (SELECT workunitID FROM jobworkunitassoc)
AND (
    workunitInputs.inputID IN (
        SELECT workunitOutputs.outputID
        FROM workunitOutputs
        LEFT JOIN workunits ON workunitOutputs.workunitID = workunits.ID
        LEFT JOIN jobworkunitassoc ON workunits.ID = jobworkunitassoc.workunitID
        LEFT JOIN jobs ON jobworkunitassoc.jobID = jobs.ID
        WHERE jobs.done = 1
    )
    OR workunitInputs.inputID IS NULL
)
AND workunitID NOT IN (
    SELECT workunits.ID
    FROM workunits
    LEFT JOIN workunitInputs ON workunits.ID = workunitInputs.workunitID
    WHERE workunitInputs.inputID NOT IN (
        SELECT workunitOutputs.outputID
        FROM workunitOutputs
        LEFT JOIN workunits ON workunitOutputs.workunitID = workunits.ID
        LEFT JOIN jobworkunitassoc ON workunits.ID = jobworkunitassoc.workunitID
        LEFT JOIN jobs ON jobworkunitassoc.jobID = jobs.ID
        WHERE jobs.done = 1
    )
    GROUP BY workunits.ID
)
GROUP BY workunits.ID