Template:UniquePassiveSkillsWizard: Difference between revisions
From Wizardia Community Wiki
Content added Content deleted
mNo edit summary Tag: Reverted |
mNo edit summary Tag: Reverted |
||
Line 7:
|join on=UniquePassiveSkills.SkillFor=Wizards.Link
|fields=CONCAT(Wizards.Link)=Link,Wizards.Name_full,UniquePassiveSkills.Description
|where={{ifeq:{{{wizardlink}}}|||UniquePassiveSkills.SkillFor='{{{wizardlink}}}' AND
|order by=UniquePassiveSkills.Name ASC
|format=template
|
Revision as of 09:36, 14 August 2023
List of Unique Passive Skills available for {{{shortname}}}:
Wizard | Description
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{ifeq:{{{wizardlink}}}|||`cargo__UniquePassiveSkills`.`SkillFor`='{{{wizardli...' at line 1
Function: CargoSQLQuery::run Query: SELECT `cargo__Wizards`.`_pageID` AS `cargo_backlink_page_id_Wizards`,`cargo__UniquePassiveSkills`.`_pageID` AS `cargo_backlink_page_id_UniquePassiveSkills`,CONCAT(`cargo__Wizards`.`Link`) AS `Link`,`cargo__Wizards`.`Name_full` AS `Name full`,`cargo__UniquePassiveSkills`.`Description` AS `Description` FROM `cargo__UniquePassiveSkills` LEFT OUTER JOIN `cargo__Wizards` ON ((`cargo__UniquePassiveSkills`.`SkillFor`=`cargo__Wizards`.`Link`)) WHERE {{ifeq:{{{wizardlink}}}|||`cargo__UniquePassiveSkills`.`SkillFor`='{{{wizardlink}}}' AND}} `cargo__Wizards`.`Rarity`='Rare' ORDER BY `cargo__UniquePassiveSkills`.`Name` LIMIT 100 |
---|