SELECT DISTINCT W.* FROM Wf.Workflows W INNER JOIN Wf.WorkflowTemplates Wt ON W.WorkflowID = Wt.WorkflowID INNER JOIN Wf.WorkflowInstances Wi ON Wt.WorkflowTemplateID = Wi.WorkflowTemplateID INNER JOIN Wf.WorkflowInstanceTasks Wit ON Wi.WorkflowInstanceID = Wit.WorkflowInstanceID WHERE WorkflowInstanceTaskStatusID = 1 --Outstanding