[Uleat]

You can try this one too..looks for inventory items not in the items table:

SELECT * FROM `inventory` WHERE `itemid` NOT IN (SELECT `id` FROM `items`);