[SQL Query] Show All MOBS and MOBID's and ITEMS DROPPED

[JZersche]

This query will show every MOB and MOB ID as well as all ITEMS and ITEM ID's that MOBS have assigned to them. This will not show the drop classes for item groups, only the data within RefMonster_AssignedItemDrop

USE SRO_VT_SHARD;

SELECT innertable.MonsterID,
       innertable.Monster,
       innertable.ItemID,
       _RefObjCommon.CodeName128 AS Item
FROM   (SELECT   _RefObjCommon.CodeName128 AS Monster,
                 _RefMonster_AssignedItemDrop.RefMonsterID AS MonsterID,
                 _RefMonster_AssignedItemDrop.RefItemID AS ItemID
        FROM     _RefMonster_AssignedItemDrop, _RefObjCommon
        WHERE    _RefMonster_AssignedItemDrop.RefMonsterID = _RefObjCommon.ID
        GROUP BY _RefObjCommon.CodeName128, _RefMonster_AssignedItemDrop.RefMonsterID, _RefMonster_AssignedItemDrop.RefItemID) AS innertable, _RefObjCommon
WHERE  innertable.ItemID = _RefObjCommon.ID;

MonsterID Monster ItemID Item
38222 MOB_SD_DESERTBUG 24669:ITEM_ETC_SD_TOKEN_03
38223 MOB_SD_SANDBUG 24669:ITEM_ETC_SD_TOKEN_03
38224 MOB_SD_DEMONBUG 24669:ITEM_ETC_SD_TOKEN_03
38225 MOB_SD_DEMONBUG_2 24669:ITEM_ETC_SD_TOKEN_03
38226 MOB_SD_DEMONBUG_3 24669:ITEM_ETC_SD_TOKEN_03
38227 MOB_SD_EVILBUG 24669:ITEM_ETC_S D_TOKEN_03
38228 MOB_SD_SELKION 24669:ITEM_ETC_SD_TOKEN_03
38229 MOB_SD_SANDSTING 24669:ITEM_ETC_SD_TOKEN_03
38230 MOB_SD_ACHNISH 24669:ITEM_ETC_SD_TOKEN_03
38231 MOB_SD_ACHNISHLAMA 24669:ITEM_ETC_SD_TOKEN_03
38232 MOB_SD_MONT 24669:ITEM_ETC_SD_TOKEN_03
And more...

You are welcome.

[denise456]

but old

[silkroadbotter]

who gives a ****, he's releasing something at least. all your doing is trying to get your post count up.

[JZersche]

And if there is another query, like this, I couldn't find it. So. I am in the progress of enhancing this to show all mobs as well, including those without drops. I may make it a separate query.