SELECTcreature_template.entry,creature_template.name,creature_template.minlevel,creature_template.maxlevel,creature_template.minhealth,creature_template.maxhealth,creature_template.rankFROMcreature_templateWHEREcreature_template.minhealth = '1' ANDcreature_template.maxhealth = '1' ANDcreature_template.minlevel > '1' ANDcreature_template.entry in (select id from creature) and creature_template.name not like '%trigger%' and creature_template.name not like '%spawn%' and creature_template.name not like '%invis%'