SELECT gi.*  FROM SIM_GeneralInfo gi JOIN User_ u ON u.userId = gi.userId LEFT JOIN SIM_FamilyMember fm ON fm.userId = u.userId LEFT JOIN SIM_Family fam ON fam.familyId = fm.familyId    WHERE(( gi.sendingOrgId = ? AND gi.status = ?) OR ( fm.familyId IN ( SELECT fm2.familyId FROM SIM_FamilyMember fm2  WHERE fm2.userId IN ( SELECT gi2.userId FROM SIM_GeneralInfo gi2 WHERE  gi2.sendingOrgId = ? AND  gi2.status = ? AND gi2.track != ?)) AND ( gi.status = ? OR (gi.status = ? AND fm.type_= ?))) AND NOT (fm.type_ = ? AND gi.sendingOrgId != ?)) AND gi.track != ? ORDER BY fam.name, fam.familyId, fm.type_, u.firstName