Difference between revisions of "Useful Queries"

From DSP Wiki
Jump to: navigation, search
(Created page with "== Find All Mobs Without Pets == <pre> select mobid, mobname, mob_pets.pet_offset from mob_spawn_points inner join mob_groups on mob_spawn_points.groupid = mob_groups.group...")
(No difference)

Revision as of 02:23, 12 November 2015

Find All Mobs Without Pets

select mobid, mobname, mob_pets.pet_offset 
from mob_spawn_points 
inner join mob_groups on mob_spawn_points.groupid = mob_groups.groupid 
inner join mob_pools on mob_groups.poolid = mob_pools.poolid 
left join mob_pets on mob_pets.mob_mobid = mob_spawn_points.mobid 
where mob_pools.mJob IN (9, 14, 15, 18) and mob_pets.pet_offset IS NULL;