Template:SpellRaritiesSpell: Difference between revisions
From Wizardia Community Wiki
Content added Content deleted
No edit summary |
No edit summary |
||
| Line 7: | Line 7: | ||
table=Spells,Wizards |
table=Spells,Wizards |
||
|join on=Spells.WizardLink=Wizards.Link |
|join on=Spells.WizardLink=Wizards.Link |
||
|fields=Wizards. |
|fields=Wizards.Name_full,Rarity,Affinity,Type,Targets,Cost,Value |
||
|where=Link='{{{spelllink}}}' |
|where=Link='{{{spelllink}}}' |
||
|order by=Value ASC |
|order by=Value ASC |
||
Revision as of 14:51, 31 October 2022
| Wizard | Rarity | Affinity | Type | Targets | Cost | Value
Error 1052: Column 'Rarity' in field list is ambiguous
Function: CargoSQLQuery::run Query: SELECT `cargo__Wizards`.`_pageID` AS `cargo_backlink_page_id_Wizards`,`cargo__Spells`.`_pageID` AS `cargo_backlink_page_id_Spells`,`cargo__Wizards`.`Name_full` AS `Name full`,`Rarity` AS `Rarity`,`Affinity` AS `Affinity`,`Type` AS `Type`,`Targets` AS `Targets`,`Cost` AS `Cost`,`Value` AS `Value` FROM `cargo__Spells` LEFT OUTER JOIN `cargo__Wizards` ON ((`cargo__Spells`.`WizardLink`=`cargo__Wizards`.`Link`)) WHERE Link='{{{spelllink}}}' ORDER BY `Value` LIMIT 100 |
|---|
