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.Name_full,Spells.Rarity,Spells.Affinity,Spells.Type,Spells.Targets,Spells.Cost,Spells.Value |
|fields=Wizards.Name_full,CONCAT(Wizards.Link)=Wizards.Link,Spells.Rarity,Spells.Affinity,Spells.Type,Spells.Targets,Spells.Cost,Spells.Value |
||
|where=Spells.Link='{{{spelllink}}}' AND Spells.Rarity=Wizards.Rarity |
|where=Spells.Link='{{{spelllink}}}' AND Spells.Rarity=Wizards.Rarity |
||
|order by=Spells.Value ASC |
|order by=Spells.Value ASC |
||
Revision as of 14:56, 31 October 2022
| Wizard | Rarity | Affinity | Type | Targets | Cost | Value
No results |
|---|
