|
|
| Line 1: |
Line 1: |
| {{#cargo_query:tables=Cards=C,CardReleases=CR
| | |
| |join on=C.ID = CR.ID
| |
| |fields=
| |
| ,CONCAT('<span class="tooltip">[[', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''), '|', CR.Title, CASE WHEN CR.Subtitle IS NULL THEN '' ELSE CONCAT(', ', CR.Subtitle) END, ' (', IFNULL(CR.CollInfo,C.CollInfo), ')]]<span>[[File:', IFNULL(CR.ImageFilename,'Card_Not_Found.jpg'), ']]</span></span>')=CardName
| |
| |where= C.CardType = 'Site' AND C.SetNum IN (1,2,3)
| |
| |order by={{StandardSort}}
| |
| |limit=400
| |
| |format=ul
| |
| |columns=3
| |
| }}
| |