Template:CardSearch: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
Line 17: | Line 17: | ||
AND ("{{{isPhysical|any}}}" = "any" OR IFNULL(CR.IsPhysical, C.IsPhysical) = {{Boolean|{{{isPhysical|any}}}}}) | AND ("{{{isPhysical|any}}}" = "any" OR IFNULL(CR.IsPhysical, C.IsPhysical) = {{Boolean|{{{isPhysical|any}}}}}) | ||
AND ("{{{isPlayable|any}}}" = "any" OR IFNULL(CR.isPlayable, C.isPlayable) = {{Boolean|{{{isPlayable|any}}}}}) | AND ("{{{isPlayable|any}}}" = "any" OR IFNULL(CR.isPlayable, C.isPlayable) = {{Boolean|{{{isPlayable|any}}}}}) | ||
AND ("{{{isErrata|any}}}" = "any" OR CR.Revision | AND ("{{{isErrata|any}}}" = "any" OR CASE WHEN {{Boolean|{{{isErrata|any}}}}} = 0 THEN CR.Revision = 0 WHEN {{Boolean|{{{isErrata|any}}}}} = 1 THEN CR.Revision > 0 END ) | ||
AND ("{{{languageName|}}}" = "" OR L.Name IN ("{{#replace:{{#replace:{{{languageName}}}|,|","}}||}}")) | AND ("{{{languageName|}}}" = "" OR L.Name IN ("{{#replace:{{#replace:{{{languageName}}}|,|","}}||}}")) | ||
Revision as of 08:18, 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.