combined containers sql guide

[knightz]

SELECT id FROM tradeskill_recipe WHERE name='Filled Penance Bag';

That will give you the id of the recipe, then just that id in place of 0000 in the other queries.

[Sensu-Bean]

ahhh.. I see.

I was doing this:

SELECT recipe_id FROM tradeskill_recipe WHERE name='Filled Penance Bag';

instead of doing:

SELECT id FROM tradeskill_recipe WHERE name='Filled Penance Bag';

thanks for the help