SELECT
creature_template.entry,
creature_template.name,
creature_template.minlevel,
creature_template.maxlevel,
creature_template.minhealth,
creature_template.maxhealth,
creature_template.rank
FROM
creature_template
WHERE
creature_template.minhealth =  '1' AND
creature_template.maxhealth =  '1' AND
creature_template.minlevel >  '1' AND
creature_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%'