$query->
        select('i.id, i.claim_code, i.updated_at, i.created_at,
          p.id,
          m.id,
          sgu.username,
          ps.id,
          ps.name,
          ps.class,
          ps.boolean_value,
          ps.integer_value,
          ps.decimal_value,
          ps.string_value,
          ps.varchar_value,
          ps.blob_value,
          ps.clob_value,
          ps.time_value,
          ps.date_value
        ')->
        leftJoin('i.Pack p')->
        leftJoin('i.Member m')->
        leftJoin('m.sfGuardUser sgu')->
        leftJoin('i.Parameters ps WITH ps.name IN ("name", "color")')
      ;