Yes there are 2 loyalty membercodes, basically it does a transportation of values to empty table rows. Transnumber cannot be joined on it's own, that's the rules. It's only a primary key with both values.
Again, even if we microfix every little detail, the issue is not there. The issue is the job doing 100 times longer than the query itself on the MSSQL tab that I'm testing it.