SELECT
  ActivityStep.ID,  
  ActivityStep.ModifiedOn AS ModifiedOn,   
  AppInstances.Name AS Workspace,   
  AppInstances.ID AS WorkspaceID,   
  ActivitySpace.Title AS ParentSpaceTitle,  
  Activity.Title AS Result,
  Activity.ID AS ParentID,
  ActivitySpace.ID AS ActivitySpaceID,  
  ActivityStep.Title AS itemTitle, 
  1 as Type, 
  ActivityStep.EndDate AS Due,
  '' as STAT, 
  UserSelection.UserID as Responsible
FROM ActivityStep
  INNER JOIN   Activity ON ActivityStep.ActivityID = Activity.ID
  INNER JOIN  ActivitySpace ON Activity.ActivitySpaceID = ActivitySpace.ID
  INNER JOIN  AppInstances ON ActivitySpace.OwnerObjectID = AppInstances.ID  
  INNER JOIN  UserSelection ON ActivityStep.ID = MasterID
WHERE
  ActivityStepStatus = 1 
  AND Category = 'ActivityStep_Responsibles'

UNION
-- PERSONAL CONTRIBUTIONS
SELECT   
  ToDo.ID, 
  ToDo.ModifiedOn AS ModifiedOn,   
  AppInstances.Name AS Workspace,     
  AppInstances.ID AS WorkspaceID,     
  ActivitySpace.Title AS ParentSpaceTitle,
  Activity.Title AS Result,
  Activity.ID AS ParentID,
  ActivitySpace.ID AS ActivitySpaceID,
  ToDo.Title AS itemTitle,
  2 as Type,
  ToDo.DueDate AS Due,   
  ToDo.Status as STAT,
  UserSelection.UserID as Responsible  
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  
  INNER JOIN  UserSelection ON ToDo.ID = MasterID
WHERE
  ObjectLink.ObjectLinkTypeID = '74D1D513-99DF-4A03-B948-E1750E32B117'   
  AND ToDo.Status != 3
  AND Category = 'ToDo_Responsibles'

UNION

-- PERSONAL MINUTES
SELECT   
  ToDo.ID, 
  ToDo.ModifiedOn AS ModifiedOn,   
  AppInstances.Name AS Workspace,     
  AppInstances.ID AS WorkspaceID,     
  Meetings.Name AS ParentSpaceTitle,
  '' AS Result,
  Meetings.ID AS ParentID,
  '' AS ActivitySpaceID,  
  ToDo.Title AS itemTitle,
  4 as Type,  --necesssario o cambio solo il valore e lascio 3?
  ToDo.DueDate AS Due,   
  ToDo.Status as STAT,
  UserSelection.UserID as Responsible  
FROM   ToDo  
  INNER JOIN   ObjectLink ON ToDo.ID = ObjectLink.ObjectID2  
  INNER JOIN   MeetingAgenda ON MeetingAgenda.ID = ObjectLink.ObjectID1
  INNER JOIN   Meetings ON Meetings.ID = MeetingAgenda.MeetingID  
  INNER JOIN   AppInstances ON ToDo.AppInstanceID = AppInstances.ID  
  INNER JOIN  UserSelection ON ToDo.ID = MasterID
WHERE
  ObjectLink.ObjectLinkTypeID = '8CD920AD-6F35-41A8-89B4-0ECB1684DB6A'
  AND ToDo.Status != 3
  AND Category = 'ToDo_Responsibles'

UNION

SELECT   
  ToDo.ID,   
  ToDo.ModifiedOn AS ModifiedOn, 
  AppInstances.Name AS Workspace,
  AppInstances.ID AS WorkspaceID,   
  ''  AS ActivitySpaceTitle,
  '' AS Result,
  '' AS ResultID,
  '' AS ActivitySpaceID,    
  ToDo.Title AS itemTitle,   
  3 as Type,
  ToDo.DueDate AS Due, 
  ToDo.Status as STAT,
  UserSelection.UserID as Responsible  
FROM   ToDo  
  INNER JOIN   AppInstances ON ToDo.AppInstanceID = AppInstances.ID  
  INNER JOIN  UserSelection ON ToDo.ID = MasterID
WHERE   
  ToDo.Status != 3 
  AND Category = 'ToDo_Responsibles'
  AND NOT EXISTS   
  (   SELECT ToDo.ID
    FROM ToDo as t
    INNER JOIN   ObjectLink ON ToDo.ID = ObjectLink.ObjectID2  
    WHERE   
    ObjectLink.ObjectLinkTypeID IN ('74D1D513-99DF-4A03-B948-E1750E32B117', '8CD920AD-6F35-41A8-89B4-0ECB1684DB6A') -- Contribution , Meeting Minute 
    AND ToDo.ID = t.ID
  )