Form:CardSearch: Difference between revisions

Revision as of 10:08, 26 September 2022

@@ Line 71: / Line 71: @@
 			<span class="heading">Is Item Class</span><small><i> (OR)</i></small>: {{{field|itemClass|input type=tokens|default=|size=40|values=
-			{{#cargo_query:tables=Cards=C,CardReleases=CR|join on=C.ID = CR.ID|fields=IF(CR.Subtypes__full IS NULL, '[Classless]', REPLACE(CR.Subtypes__full, ',', ' • '))|where=C.CardType IN ('Artifact', 'Possession')|format=list|group by=Subtypes__full|no html}}|placeholder=Select 1 or more}}}
+			{{#replace:{{#replace:{{#cargo_query:tables=Cards=C,CardReleases=CR|join on=C.ID = CR.ID|fields=IF(CR.Subtypes__full IS NULL, '[Classless]', CR.Subtypes__full)|where=C.CardType IN ('Artifact', 'Possession') AND CR.Subtypes__full NOT LIKE '%,%' |format=list|group by=Subtypes__full|order by=CASE WHEN CR.Subtypes__full IS NULL THEN 0 ELSE 1 END,CR.Subtypes__full|no html}}|<p>|}}|</p>|}}|placeholder=Select 1 or more}}}
 			<div class="mw-collapsible-content">