80,736
edits
No edit summary |
No edit summary |
||
Line 4: | Line 4: | ||
|join on=CardData._pageName=SetData._pageName,SetData.SetName=SetInfo.SetName | |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=CardData.Artist='{{PAGENAME}}' AND (CardData.Name NOT LIKE '%Wonder (Anomaly)%') AND (CardData.Name NOT LIKE '%Valoocanth (Anomaly)%' | |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 |