[TUT] How to customize drop table(s)

use Arcadia

 --> change the red code numeric to search your desired ID.
DECLARE @id int = ( SELECT id FROM itemresource where id = '503001' ) 
 --> checking the identity of the item to determine the name of the id.
DECLARE @name_id int = ( SELECT name_id FROM itemresource where id = @id )
 --> checking the essentials of the id. 
SELECT id,type,class,rank,[level],socket,drop_type FROM itemresource where id = @id
 --> checking the identity of the stated item.
SELECT  value FROM stringresource where code = @name_id
--> multiple searches at once.
SELECT * from DropGroupResource where 
   (drop_item_id_00 = @id) 
or (drop_item_id_01 = @id) 
or (drop_item_id_02 = @id)
or (drop_item_id_03 = @id)
or (drop_item_id_04 = @id)
or (drop_item_id_05 = @id) 
or (drop_item_id_06 = @id)
or (drop_item_id_07 = @id)
or (drop_item_id_08 = @id)
or (drop_item_id_09 = @id)

--> Credits : misterd @ 2012