Druid Sql “Detected duplicate prefix”

Trying to run an Druid SQL query which only return rows where either the columnA value is in a list of values from a sub query, OR columnB is in a list of different (but potentially) overlapping values. They don’t both have to be in their respective list, but at least one needs to be.

WHERE colA IN (SELECT colX From XX where colY = 1)
OR colB IN (SELECT colX FROM XX where colY = 2)

I get the error
Unknown Exception / Detected duplicate prefix in join clauses

I have no idea what this error is trying to tell me. It works fine with the AND operator, just has issues with the OR... any help appreciated!