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