The refactor in e9aaaa835f194b9416db102d908e1e5a0cd48f84 unintentionally
lost this constraint: the relevant WHERE clause is in a JOIN, and in
that commit that JOIN turned into a LEFT JOIN. Here I've resolved
that by hoisting the restriction up to the outer query's WHERE clause.
The refactor in e9aaaa835f194b9416db102d908e1e5a0cd48f84 unintentionally lost this constraint: the relevant
WHERE
clause is in aJOIN
, and in that commit thatJOIN
turned into aLEFT JOIN
. Here I've resolved that by hoisting the restriction up to the outer query'sWHERE
clause.