Template:Sandbox/Aurelain/SpellsNavbox/row: Difference between revisions
From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary |
No edit summary |
||
| Line 28: | Line 28: | ||
| where = | | where = | ||
S.school = '{{{school}}}' | S.school = '{{{school}}}' | ||
AND s.id NOT LIKE '%masterful%' | |||
AND T.type = 'spell' | AND T.type = 'spell' | ||
AND T.language = '{{{lang|en}}}' | AND T.language = '{{{lang|en}}}' | ||
Revision as of 20:20, 22 June 2026
Input:
{{Sandbox/Aurelain/SpellsNavbox/row
|lang=en
|school=day
}}
Output:
| No results
|
Error 1054: Unknown column 's.id' in 'WHERE'
Function: CargoSQLQuery::run Query: SELECT `E`.`_pageID` AS `cargo_backlink_page_id_E`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`S`.`_pageID` AS `cargo_backlink_page_id_S`,`S`.`id` AS `id`,`T`.`language` AS `lang`,`T`.`name` AS `name`,`E`.`name` AS `name_en` FROM `mw4v_cargo__Spell` `S` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`S`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `E` ON ((`S`.`id`=`E`.`target_id`)) WHERE `S`.`school` = 'day'
AND `s`.`id` NOT LIKE '%masterful%' AND `T`.`type` = 'spell' AND `T`.`language` = 'en' AND `E`.`type` = 'spell' AND `E`.`language` = 'en' ORDER BY `S`.`rank` LIMIT 100
}
