I've just come across where

itemid

field is returning results if there is a vendor code matching as well, it seems to be solved by changing to

nameinternal