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: | ||
Translation=hero_t | Translation=hero_t | ||
|join on = H.id = hero_t.target_id | |join on = H.id = hero_t.target_id | ||
|where = H. | |where = H.faction = '{{{demon}}}' | ||
AND hero_t.language = '{{{lang|en}}}' | AND hero_t.type = 'hero' AND hero_t.language = '{{{lang|en}}}' | ||
AND H.class_type = 'might' | |||
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%' | ||
|order by= hero_t.name | |||
|fields = CONCAT('hero') = type, | |fields = CONCAT('hero') = type, | ||
H.id = id, | H.id = id, | ||
CONCAT('{{{lang|en}}}') = lang | CONCAT('{{{lang|en}}}') = lang | ||
|format = | |format = template | ||
|template=Link | |||
|delimiter= • | |||
|named args = yes | |named args = yes | ||
}} | }} | ||
|} | |} | ||
</includeonly> | </includeonly> | ||
