use Arcadia
DECLARE @id int = 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)