SELECT "contracts_contracts"."id", "contracts_agreements"."code_for_apply_agreement"
FROM "contracts_contracts"
    INNER JOIN "contracts_agreements"
        ON ("contracts_contracts"."agreement_id" = "contracts_agreements"."id")
WHERE UPPER("contracts_agreements"."code_for_apply_agreement"::text)
          LIKE UPPER('%hightel%')
GROUP BY "contracts_contracts"."id", "contracts_agreements"."code_for_apply_agreement"