Simpler query to reproduce on above-mentioned tables:
select outr . `col_text`
from bb as outr
where outr . `col_bigint_key` IN (SELECT innr . `pk` AS y FROM bb AS innr WHERE
innr . `col_bigint_key` > innr . `col_int`)
AND outr . `col_bigint_key` = 9;
Simpler query to reproduce on above-mentioned tables:
select outr . `col_text`
FROM bb AS innr
WHERE
from bb as outr
where outr . `col_bigint_key` IN (SELECT innr . `pk` AS y
innr . `col_bigint_key` > innr . `col_int`)
AND outr . `col_bigint_key` = 9;