Template:CardSearch: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
Line 7: | Line 7: | ||
,CONCAT("{{{creator|}}}")=Creator | ,CONCAT("{{{creator|}}}")=Creator | ||
|where= ('{{{isUnique|any}}}' = 'any' OR CR.IsUnique = CASE WHEN '{{{isUnique|any}}}' = 'yes' THEN 1 WHEN '{{{isUnique|any}}}' = 'no' THEN 0 ELSE 2 END) | |where= ('{{{isUnique|any}}}' = 'any' OR CR.IsUnique = CASE WHEN '{{{isUnique|any}}}' = 'yes' THEN 1 WHEN '{{{isUnique|any}}}' = 'no' THEN 0 ELSE 2 END) | ||
AND ("{{{creator|}}}" = "" OR "{{{creator|}}}" LIKE CONCAT('%', S.Creator, '%')) | |||
|order by={{{sort|{{CultureSort}}}}} | |order by={{{sort|{{CultureSort}}}}} | ||
|limit=100 | |limit=100 |
Revision as of 22:47, 24 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.