ok, problem solved
when writing down everything here and going through the data again trying to make it understandable, i realized that there was a missing entry in my table.
Well, as good ol' Konfuzius already said: If data missing you cannot see.
heck, what a shame
ie, my query does work if correct/all data is provided
and now, frez, :x