ru.stackoverflow.com/questions/778781/

/*
CREATE FUNCTION [dbo].[generate_series_2](@start int, @end int)
RETURNS TABLE
AS
RETURN
(
    WITH CTE AS
    (
        SELECT num = @start
        UNION ALL
        SELECT num + 1 FROM CTE WHERE (num < @end)
    )

    SELECT num
    FROM CTE
)
*/

with g as
(
    select "chr", "hkey" = s."num", "left", "right", "name"
    from "genes-g38-201505" g
    cross apply generate_series_2(g."left" / 10000, g."right" / 10000) s
),

r as
(
    select "chr", "hkey" = s."num", "left", "right", "name"
    from "repeats-g38-201505" r
    cross apply generate_series_2(r."left" / 10000, r."right" / 10000) s
)

select
    a."chr", a."left", a."right",
    a."count" as "count_k47",
    g."name" as "name_left",
    r."name" as "name_right"
from
    "47k-80-80-ignore-random-noreverse" a
    inner hash join g on
      (a."chr" = g."chr") and
      (a."left" / 10000 = g."hkey") and
      (a."left" / 10000 = g."hkey") and
      (g."left" < a."left") and (a."left" < g."right")
    inner hash join r on
      (a."chr" = r."chr") and
      (a."right" / 10000 = r."hkey") and
      (a."right" / 10000 = r."hkey") and
      (r."left" < a."right") and (a."right" < r."right")

option (maxrecursion 0)