No, part of that is my misreading what you posted...
I thought that you had typed
doesn't work for the "Pieces Of The Iceclad Map" recipe as well...
I would, if this is your server, manually summon the items that are required and verify that the recipe works that way.
Code:
SELECT `id`, `name` FROM `items` WHERE `name` IN (SELECT `name` FROM `items` WHERE `id` IN (SELECT `item_id` id FROM `tradeskill_recipe_entries` WHERE `recipe_id` = '9822'));
doesn't show duplicate items in my database.