This should find ALL jewelcrafting recipes:
Code:
SELECT * from tradeskill_recipe_entries JOIN tradeskill_recipe ON tradeskill_recipe_entries.recipe_id=tradeskill_recipe.id WHERE tradeskill_recipe.tradeskill=68;
I would think you would want to insert item_id 17187 for any recipe where it is not
already included, a good many of them seem to have it already.