WITH subquery AS (
  SELECT (%s BETWEEN init_ver AND last_ver) X_includes
       , (%s BETWEEN init_ver AND last_ver) Y_includes
       , *
  FROM {table_name} T
  JOIN {intervals_name} I ON I.row_hash = T._hash
)
SELECT {x_fields}
FROM (SELECT * FROM subquery WHERE X_includes) X
LEFT JOIN (SELECT _hash FROM subquery WHERE Y_includes) Y
ON X._hash = Y._hash
WHERE Y._hash IS NULL ORDER BY {order};