Editing Signets
From LOTR-TCG Wiki
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 40: | Line 40: | ||
|where= C.SetNum <> 0 | |where= C.SetNum <> 0 | ||
AND CR.GameText LIKE '%signet%' | AND CR.GameText LIKE '%signet%' | ||
|order by=TRIM(CASE WHEN CR.GameText LIKE '%Aragorn signet%' THEN 'Aragorn' WHEN CR.GameText LIKE '%Frodo signet%' THEN 'Frodo' WHEN CR.GameText LIKE '%Gandalf signet%' THEN 'Gandalf' WHEN CR.GameText LIKE '%Theoden signet%' THEN 'Theoden' ELSE 'None' END), | |order by=TRIM(CASE WHEN CR.GameText LIKE '%Aragorn signet%' THEN 'Aragorn' WHEN CR.GameText LIKE '%Frodo signet%' THEN 'Frodo' WHEN CR.GameText LIKE '%Gandalf signet%' THEN 'Gandalf' WHEN CR.GameText LIKE '%Theoden signet%' THEN 'Theoden' ELSE 'None' END), C.SetNum, C.CardNum | ||
|limit=100 | |limit=100 | ||
|rows per page=26 | |rows per page=26 | ||
Line 62: | Line 62: | ||
AND C.CardType = 'Companion' | AND C.CardType = 'Companion' | ||
AND CR.Signet <> 'None' | AND CR.Signet <> 'None' | ||
|order by=CR.Signet, | |order by=CR.Signet, C.SetNum, C.CardNum | ||
|limit=110 | |limit=110 | ||
|rows per page=107 | |rows per page=107 |