Thread: Spell research
View Single Post
  #3  
Old 01-13-2022, 06:59 AM
EQEmpires
Banned
 
Join Date: Mar 2021
Posts: 14
Default

Code:
SELECT DISTINCT
	items.id,
	items.name,
	items.bagtype 
FROM
	tradeskill_recipe_entries
	INNER JOIN tradeskill_recipe ON tradeskill_recipe.id = tradeskill_recipe_entries.recipe_id
	INNER JOIN items ON tradeskill_recipe_entries.item_id = items.id 
WHERE
	tradeskill = 58 
	AND tradeskill_recipe_entries.iscontainer = 1;
The above query will allow you to select any containers that are part of a Research Combine DB-wide. Maybe it could help some people who may not know how to grab them from DB to do the suggested change.
Reply With Quote