80,736
edits
Template:ArtistsCards: Difference between revisions
From Archon Arcana - The KeyForge Wiki
no edit summary
Blinkingline (talk | contribs) Tag: Reverted |
No edit summary |
||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
== KeyForge cards featuring art by {{PAGENAME}} == | == KeyForge cards featuring art by {{PAGENAME}} == | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=CardData,SetInfo | tables=CardData,SetData,SetInfo | ||
|join on=CardData._pageName=SetData._pageName, | |join on=CardData._pageName=SetData._pageName,SetData.SetName=SetInfo.SetName | ||
|fields=CardData.Artist, CardData.Image, CardData.Name | |fields=CardData.Artist, CardData.Image, CardData.Name | ||
|where= | |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.Artist, CardData.Image, CardData.Name | |group by=CardData.Artist, CardData.Image, CardData.Name | ||
|order by=CardData.Name ASC | |order by=CardData.Name ASC | ||
| Line 17: | Line 17: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=CardData,SetInfo | tables=CardData,SetData,SetInfo | ||
|join on=CardData._pageName=SetData._pageName, | |join on=CardData._pageName=SetData._pageName,SetData.SetName=SetInfo.SetName | ||
|fields=CardData.Artist | |fields=CardData.Artist | ||
|where=(CardData.Artist= | |where=(CardData.Artist='{{PAGENAME}}' AND (CardData.Name NOT LIKE '%Wonder (Anomaly)%') AND (CardData.Name NOT LIKE '%Valoocanth (Anomaly)%')) AND (SetInfo.SetNumber like '%KFA%') | ||
|limit=1 | |limit=1 | ||
|format=template | |format=template | ||