Template:Sandbox/Aurelain/HeroesNavbox: Difference between revisions
From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary |
No edit summary |
||
| Line 13: | Line 13: | ||
|join on = H.id=hero_t.target_id | |join on = H.id=hero_t.target_id | ||
|where = H.class_type='magic_demon' | |where = H.class_type='magic_demon' | ||
AND hero_t.type | AND hero_t.type='hero' | ||
AND hero_t.language='{{{lang|en}}}' | |||
AND H.id NOT LIKE 'campaign%' | AND H.id NOT LIKE 'campaign%' | ||
AND H.id NOT LIKE 'tutorial%' | AND H.id NOT LIKE 'tutorial%' | ||
AND H.id NOT LIKE 'cm_fun%' | AND H.id NOT LIKE 'cm_fun%' | ||
|fields = CONCAT('hero') = type, | |||
H.id = id, | |||
CONCAT('{{{lang|en}}}') = lang | |||
|order by = hero_t.name | |order by = hero_t.name | ||
|limit = 20 | |limit = 20 | ||
