Template:UniquePassiveSkillsWizard: Difference between revisions
From Wizardia Community Wiki
Content added Content deleted
mNo edit summary |
mNo edit summary Tag: Reverted |
||
Line 7: | Line 7: | ||
|join on=UniquePassiveSkills.SkillFor=Wizards.Link |
|join on=UniquePassiveSkills.SkillFor=Wizards.Link |
||
|fields=CONCAT(Wizards.Link)=Link,Wizards.Name_full,UniquePassiveSkills.Description |
|fields=CONCAT(Wizards.Link)=Link,Wizards.Name_full,UniquePassiveSkills.Description |
||
|where=UniquePassiveSkills.SkillFor='{{{wizardlink}}}' AND Wizards.Rarity='Rare' |
|where={{ifeq:{{{wizardlink}}}|||UniquePassiveSkills.SkillFor='{{{wizardlink}}}' AND }}Wizards.Rarity='Rare' |
||
|order by=UniquePassiveSkills.Name ASC |
|order by=UniquePassiveSkills.Name ASC |
||
|format=template |
|format=template |
Revision as of 09:33, 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 |
---|