-- PERSONAL CONTRIBUTIONS
SELECT   
  ToDo.ID, 
  ToDo.ModifiedOn AS ModifiedOn,   
  AppInstances.Name AS Workspace,     
  AppInstances.ID AS WorkspaceID,     
  ActivitySpace.Title AS ActivitySpaceTitle,
  Activity.Title AS Result,
  ToDo.Title AS itemTitle,
  2 as Type,
  ToDo.DueDate AS Due,   
  ToDo.Status as STAT

FROM   ToDo  
INNER JOIN   ObjectLink ON ToDo.ID = ObjectLink.ObjectID2  
INNER JOIN   ActivityStep ON ActivityStep.ID = ObjectLink.ObjectID1  
INNER JOIN   Activity ON ActivityStep.ActivityID = Activity.ID  
INNER JOIN   ActivitySpace ON Activity.ActivitySpaceID = ActivitySpace.ID  
INNER JOIN   AppInstances ON ToDo.AppInstanceID = AppInstances.ID  

WHERE   
ObjectLink.ObjectLinkTypeID = '74D1D513-99DF-4A03-B948-E1750E32B117' 
AND ToDo.Status != 3
AND ToDo.ID IN   
(    SELECT     MasterID    FROM     UserSelection    WHERE     Category = 'ToDo_Responsibles' AND     UserID = 'CCFA217B-EC15-4B3E-A99C-E3E23D9FF53E'   )

UNION

--TODO
SELECT   
  ToDo.ID,   
  ToDo.ModifiedOn AS ModifiedOn, 
  AppInstances.Name AS Workspace,
  AppInstances.ID AS WorkspaceID,   
  ''  AS ActivitySpaceTitle,
  '' AS Result,
  ToDo.Title AS itemTitle,   
  3 as Type,
  ToDo.DueDate AS Due, 
  ToDo.Status as STAT
   
FROM   ToDo  
INNER JOIN   AppInstances ON ToDo.AppInstanceID = AppInstances.ID  

WHERE   ToDo.Status != 3 
AND ToDo.ID IN   
( SELECT     MasterID    
  FROM     UserSelection    
  WHERE     Category = 'ToDo_Responsibles' AND UserID = 'CCFA217B-EC15-4B3E-A99C-E3E23D9FF53E')
  AND ToDo.ID NOT IN   
 (  SELECT ToDo.ID
  FROM ToDo  
  INNER JOIN   ObjectLink ON ToDo.ID = ObjectLink.ObjectID2  
  WHERE   
  ObjectLink.ObjectLinkTypeID = '74D1D513-99DF-4A03-B948-E1750E32B117' )