    <View>
      <ID>PlacedStatus(MergeRestrictAll)</ID>
      <Caption>Placed</Caption>
      <Properties>2629</Properties>
      <SQL>SELECT Requirements.ReqIntID,Requirements.ReqID as Requirement,Requirements.JobTitle,Requirements.Location,
                  Contacts.DisplayName as Contact,Contacts.CompanyName as Company, 
                  Consultants.DisplayName as Consultant,Reminders.ApptType as Type,Reminders.ApptSubType as SubType,
                  Reminders.StartDateTime AS DateAndTime,Reminders.UserIDs 
           FROM Reminders, Links b, Links c, Links d, Contacts, Requirements, Consultants  
           WHERE (Consultants.Private=False OR Consultants.UserIDs LIKE [LoggedInUser]) AND 
                 (Requirements.Private=False OR Requirements.UserIDs LIKE [LoggedInUser]) AND 
                  Requirements.Archived = False AND
                  Reminders.RemType='Status' AND Reminders.ApptType='Status' AND 
			(Reminders.ApptSubType='Placed' OR Reminders.ApptSubType='Hired') AND
                 (Reminders.RemIntID=b.FromID and b.ToID=Contacts.ContactIntID) AND 
                 (Reminders.RemIntID=c.FromID and c.ToID=Consultants.ConsIntID) AND 
                 (Reminders.RemIntID=d.FromID and d.ToID=Requirements.ReqIntID) 
	       ORDER BY Requirements.ReqID ASC, Consultants.DisplayName ASC, Reminders.StartDateTime Desc</SQL>
    </View>