View Single Post
  #8  
Old 09-09-2014, 07:50 PM
Shendare
Dragon
 
Join Date: Apr 2009
Location: California
Posts: 814
Default

This should do what you need it to do:

Code:
INSERT INTO tradeskill_recipe_entries (recipe_id, item_id, successcount, failcount, componentcount, salvagecount, iscontainer) SELECT r.id, 17187, 0, 0, 0, 0, 1 FROM tradeskill_recipe r WHERE r.tradeskill=68 AND r.id NOT IN (SELECT recipe_id FROM tradeskill_recipe_entries e WHERE e.item_id=17187);
Reply With Quote