DELETE FROM CitationTable
WHERE CitationID IN
(
SELECT C.CitationID
FROM CitationTable AS C
        LEFT JOIN
     SourceTable AS S ON S.SourceID = C.SourceID
        LEFT JOIN
     EventTable AS E ON E.EventID = C.OwnerID
         LEFT JOIN
     FactTypeTable AS FT ON FT.FactTypeID = E.EventType   
WHERE C.OwnerType = 2 AND E.EventID IS NULL         
ORDER BY S.Name
)
;