Template:Sandbox/Aurelain/HeroesNavbox: Difference between revisions
From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary |
No edit summary |
||
| Line 10: | Line 10: | ||
|{{LinkIcon|type=hero_class|id=magic_demon|lang={{{lang}}}}} | |{{LinkIcon|type=hero_class|id=magic_demon|lang={{{lang}}}}} | ||
|{{#cargo_query: | |{{#cargo_query: | ||
tables = Hero=H, Translation= | tables = Hero=H, Translation=hero_t | ||
|join on = H.id= | |join on = H.id=hero_t.target_id | ||
|where = H.class_type='magic_demon' | |where = H.class_type='magic_demon' | ||
AND | 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%' | ||
|order by = | |order by = hero_t.name | ||
|limit = 20 | |limit = 20 | ||
|format = table | |format = table | ||
Revision as of 13:09, 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` `hero_t` ON ((`H`.`id`=`hero_t`.`target_id`)) WHERE `H`.`class_type`='magic_demon' AND `hero_t`.`type` = 'hero' AND `hero_t`.`language` = 'ja'
AND `H`.`id` NOT LIKE 'campaign%'
AND `H`.`id` NOT LIKE 'tutorial%'
AND `H`.`id` NOT LIKE 'cm_fun%' ORDER BY `hero_t`.`name` LIMIT 20
|
