Template:CardSearch: Difference between revisions

Revision as of 09:01, 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.

@@ Line 19: / Line 19: @@
 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 ("{{#replace:{{{loreSearch|}}}|"|}}" = "" OR CR.Lore RLIKE CONCAT("%", "{{#replace:{{{loreSearch|}}}|"|}}", "%"))
+AND ("{{#replace:{{{loreSearch|}}}|"|}}" = "" OR EN.Lore RLIKE {{#replace:{{{loreSearch|}}}|"|}})
 |order by={{{sort|{{CultureSort}}}}}