Template:Sandbox/Aurelain/HeroesNavbox: Difference between revisions
From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary |
No edit summary |
||
| Line 9: | Line 9: | ||
|- | |- | ||
|{{LinkIcon|type=hero_class|id=magic_demon|lang={{{lang}}}}} | |{{LinkIcon|type=hero_class|id=magic_demon|lang={{{lang}}}}} | ||
|{{#cargo_query:tables=Hero | |{{#cargo_query: | ||
| | tables = Hero=H, Translation=T | ||
|where = | |join on = H.id=T.target_id | ||
|order by = | |where = H.class_type='magic_demon' | ||
|limit = | AND T.type = 'hero' AND T.language = '{{{lang|en}}}' | ||
|format = | AND H.id NOT LIKE 'campaign%' | ||
AND H.id NOT LIKE 'tutorial%' | |||
AND H.id NOT LIKE 'cm_fun%' | |||
|order by = T.name | |||
|limit = 20 | |||
|format = table | |||
}} | }} | ||
|} | |} | ||
</includeonly> | </includeonly> | ||
Revision as of 13:07, 19 June 2026
{{Sandbox/Aurelain/HeroesNavbox|lang=ja}}
| Hero Classes | |
|---|---|
 ヘラルド
|
Error 1052: Column '_pageName' in SELECT is ambiguous
Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `_pageName` FROM `mw4v_cargo__Hero` `H` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`H`.`id`=`T`.`target_id`)) WHERE `H`.`class_type`='magic_demon' AND `T`.`type` = 'hero' AND `T`.`language` = 'ja'
AND `H`.`id` NOT LIKE 'campaign%'
AND `H`.`id` NOT LIKE 'tutorial%'
AND `H`.`id` NOT LIKE 'cm_fun%' ORDER BY `T`.`name` LIMIT 20
|
