-- Find items with no parent
SELECT ID 
FROM Items i1 
WHERE i1.ParentID <> '00000000-0000-0000-0000-000000000000' AND NOT EXISTS(SELECT ID FROM Items i2 WHERE i2.ID = i1.ParentID)