Maybe I need an English description of your data and the results you want to produce. The document boundaries are not clear to me.
Another approach might be:
SELECT ... FROM ... WHERE sku IN (SELECT RAW ... FROM ...);
In the subquery, you would generate all values you want to match.