uuApplywithindeed Apply With Indeed SELECT Consultants.ConsIntID,Requirements.ReqID,Consultants.CreateDate,Consultants.ConsultantID,Consultants.DisplayName,Consultants.LastName,Consultants.HomePhone,Consultants.WorkPhone,Consultants.MobilePhone,Requirements.JobTitle,Consultants.EMail1,Consultants.PrimarySkills,Consultants.City,Consultants.State,Consultants.Categories,Consultants.Groups,Consultants.Owners,Consultants.UserIDs,Consultants.EditDate FROM Requirements,Links b,MLinkInfo,Contacts d,Links e,Consultants WHERE (Requirements.ReqIntID=b.ToID AND b.FromID=Consultants.ConsIntID AND b.Type=2 AND b.SubType=1 AND b.FromID=MLinkInfo.FromID AND Requirements.ReqIntID=MLinkInfo.ToID AND MLinkInfo.Type=2 AND MLinkInfo.SubType=1) AND (Requirements.ReqIntID=e.FromID AND e.ToID=d.ContactIntID AND e.Type=1 AND e.SubType=1) AND (MLinkInfo.Subject = 'Resume Submission') AND (Consultants.Private=False OR Consultants.UserIDs LIKE [LoggedInUser]) 54269