12,417
edits
Template:ArtistsCards: Difference between revisions
From Archon Arcana - The KeyForge Wiki
Undo revision 105588 by Coffeesaga (talk)
Coffeesaga (talk | contribs) No edit summary |
Coffeesaga (talk | contribs) (Undo revision 105588 by Coffeesaga (talk)) Tag: Undo |
||
| Line 3: | Line 3: | ||
tables=CardData,SetInfo,SetData | tables=CardData,SetInfo,SetData | ||
|join on=SetData.Setname=SetInfo.Setname, SetData._pageName=CardData._pageName | |join on=SetData.Setname=SetInfo.Setname, SetData._pageName=CardData._pageName | ||
|fields=CardData.Name | |fields=CardData.Artist, CardData.Image, CardData.Name, SetInfo.SetName | ||
|where=(CardData.Artist='{{PAGENAME}}' AND (CardData.Name NOT LIKE '%Wonder (Anomaly)%') AND (CardData.Name NOT LIKE '%Valoocanth (Anomaly)%')) AND (SetInfo.SetNumber not like '%KFA%') | |where=(CardData.Artist='{{PAGENAME}}' AND (CardData.Name NOT LIKE '%Wonder (Anomaly)%') AND (CardData.Name NOT LIKE '%Valoocanth (Anomaly)%')) AND (SetInfo.SetNumber not like '%KFA%') | ||
|group by=CardData.Name | |group by=CardData.Artist, CardData.Image, CardData.Name, SetInfo.SetName | ||
|order by=CardData.Name ASC | |order by=CardData.Name ASC | ||
|limit=300 | |limit=300 | ||