Template:CardSearch: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
Line 43: | Line 43: | ||
AND ("{{{signet|}}}" = "" OR CR.Signet = "{{{signet|}}}") | AND ("{{{signet|}}}" = "" OR CR.Signet = "{{{signet|}}}") | ||
|group by=C._pageName, CR.LanguageCode, CR.Revision | AND ("{{{block|}}}" = "" OR (C.CardType = 'Site' AND CR.Block = "{{{block|}}}")) | ||
AND ("{{{sitesitenum|}}}" = "" OR (C.CardType = 'Site' AND CR.SiteNum = "{{{sitesitenum|}}}")) | |||
AND ("{{{sitesitenumMore|}}}" = "" OR (C.CardType = 'Site' AND CR.SiteNum >= "{{{sitesitenumMore|}}}")) | |||
AND ("{{{sitesitenumLess|}}}" = "" OR (C.CardType = 'Site' AND CR.SiteNum <= "{{{sitesitenumLess|}}}")) | |||
AND ("{{{shadownum|}}}" = "" OR (C.CardType = 'Site' AND IFNULL(CR.ShadowNumber, CR.TwilightCost) = "{{{shadownum|}}}")) | |||
AND ("{{{shadownumMore|}}}" = "" OR (C.CardType = 'Site' AND IFNULL(CR.ShadowNumber, CR.TwilightCost) >= "{{{shadownumMore|}}}")) | |||
AND ("{{{shadownumLess|}}}" = "" OR (C.CardType = 'Site' AND IFNULL(CR.ShadowNumber, CR.TwilightCost) <= "{{{shadownumLess|}}}")) | |||
AND ("{{{isSanctuary|any}}}" = "" OR CASE WHEN {{Boolean|{{{isSanctuary|any}}}}} = 1 THEN CR.GameText RLIKE '(?<!\\w )Sanctuary\\.' ELSE CR.GameText NOT RLIKE '(?<!\\w )Sanctuary\\.') | |||
AND ("{{{arrowDir|any}}}" = "any" OR CR.ArrowDir = "{{{arrowDir|any}}}") | |||
|group by=C._pageName, CR.LanguageCode, CR.Subset, CR.Revision | |||
|order by={{{sort|{{CultureSort}}}}} | |order by={{{sort|{{CultureSort}}}}} | ||
|limit=100 | |limit=100 |
Revision as of 22:53, 25 September 2022
This is the "CardSearch" template.
It should be called in the following format:
{{CardSearch |isUnique= |sort= }}
Edit the page to see the template text.