Code:
SELECT distinct race, size
FROM
npc_types
WHERE (race >= '1' AND race <= '12') AND (size >= '3' AND size <= '9')
ORDER BY race ASC;
Would just have to poke in race= for iksar, vah-shir and drakin if you needed that info.
On my test db this returned interesting values so I inserted id in the select line so I could go check out what each odd sized npc was doing.
I limited my search to sizes between 3 and 9 because I remember reading on the wiki or a post how short races should be around size 3 and I know there are some custom npc in the stock peq db with size values greater then 15 and did not think I would see any large race over size 9.
Interesting post, gave me a chance to google up sql stuff and figure out how to do this search. Might not be useful or the best way but at least I learned something, hope it helps you.
Threaded Mode
