Form:CardSearch - Revision history

Teltura: fixing keyword dropdowns not having Ring-bearer

2024-06-28T04:44:49Z

fixing keyword dropdowns not having Ring-bearer

← Older revision		Revision as of 04:44, 28 June 2024
Line 52:		Line 52:
	</div>		</div>

	<span class="heading">Has Keyword</span><small><i> (OR)</i></small>: {{{field\|keyword\|input type=tokens\|default=\|size=40\|values=Ambush,Archer,Battleground,Besieger,Corsair,Damage +1,Damage +2,Defender +1,Dwelling,Easterling,Enduring,Engine,Fierce,Forest,Fortification,Hunter,Knight,Lurker,Machine,Marsh,Mountain,Mounted,Muster,Pipeweed,Plains,Ranger,Ring-bound,River,Roaming,Sanctuary,Search,Southron,Spell,Stealth,Tale,Tentacle,Toil,Tracker,Twilight,Unbound,Underground,Unhasty,Valiant,Villager,Warg-rider,Weather,Burglar,Cunning,Wise\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Has Keyword</span><small><i> (OR)</i></small>: {{{field\|keyword\|input type=tokens\|default=\|size=40\|values=Ambush,Archer,Battleground,Besieger,Corsair,Damage +1,Damage +2,Defender +1,Dwelling,Easterling,Enduring,Engine,Fierce,Forest,Fortification,Hunter,Knight,Lurker,Machine,Marsh,Mountain,Mounted,Muster,Pipeweed,Plains,Ranger,Ring-bearer,Ring-bound,River,Roaming,Sanctuary,Search,Southron,Spell,Stealth,Tale,Tentacle,Toil,Tracker,Twilight,Unbound,Underground,Unhasty,Valiant,Villager,Warg-rider,Weather,Burglar,Cunning,Wise\|existing values only\|placeholder=Select 1 or more}}}
	</div>		</div>
	</div>		</div>
Line 161:		Line 161:
	{{#cargo_query:tables=Cards=C,CardReleases=CR\|join on=C.ID = CR.ID\|fields=CR.Subtypes__full\|where=C.CardType IN ('Artifact', 'Possession') AND CR.Subtypes__full IS NOT NULL AND CR.Subtypes__full NOT LIKE '%,%' AND CR.Subtypes__full NOT LIKE '%Support Area%'\|format=template\|template=TagFilterOutput\|group by=Subtypes__full\|no html}}\|existing values only\|placeholder=Select 1 or more}}}		{{#cargo_query:tables=Cards=C,CardReleases=CR\|join on=C.ID = CR.ID\|fields=CR.Subtypes__full\|where=C.CardType IN ('Artifact', 'Possession') AND CR.Subtypes__full IS NOT NULL AND CR.Subtypes__full NOT LIKE '%,%' AND CR.Subtypes__full NOT LIKE '%Support Area%'\|format=template\|template=TagFilterOutput\|group by=Subtypes__full\|no html}}\|existing values only\|placeholder=Select 1 or more}}}

	<span class="heading">Uses Keyword</span><small><i> (OR)</i></small>: {{{field\|usesKeyword\|input type=tokens\|default=\|size=40\|values=Ambush,Archer,Battleground,Besieger,Corsair,Damage,Defender,Dwelling,Easterling,Enduring,Engine,Fierce,Forest,Fortification,Hunter,Knight,Lurker,Machine,Marsh,Mountain,Mounted,Muster,Pipeweed,Plains,Ranger,Ring-bound,River,Roaming,Sanctuary,Search,Southron,Spell,Stealth,Tale,Tentacle,Toil,Tracker,Twilight,Unbound,Underground,Unhasty,Valiant,Villager,Warg-rider,Weather,Burglar,Cunning,Wise\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Uses Keyword</span><small><i> (OR)</i></small>: {{{field\|usesKeyword\|input type=tokens\|default=\|size=40\|values=Ambush,Archer,Battleground,Besieger,Corsair,Damage,Defender,Dwelling,Easterling,Enduring,Engine,Fierce,Forest,Fortification,Hunter,Knight,Lurker,Machine,Marsh,Mountain,Mounted,Muster,Pipeweed,Plains,Ranger,Ring-bearer,Ring-bound,River,Roaming,Sanctuary,Search,Southron,Spell,Stealth,Tale,Tentacle,Toil,Tracker,Twilight,Unbound,Underground,Unhasty,Valiant,Villager,Warg-rider,Weather,Burglar,Cunning,Wise\|existing values only\|placeholder=Select 1 or more}}}
	</div>		</div>

Teltura: Fixing Race, Item Class, and Rarity filters not working properly

2024-01-25T02:30:42Z

Fixing Race, Item Class, and Rarity filters not working properly

Teltura at 02:28, 25 January 2024

2024-01-25T02:28:44Z

← Older revision		Revision as of 02:28, 25 January 2024
Line 26:		Line 26:

	<span class="heading">Is Race</span><small><i> (OR)</i></small>: {{{field\|race\|input type=tokens\|default=\|size=40\|values=		<span class="heading">Is Race</span><small><i> (OR)</i></small>: {{{field\|race\|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, '[Raceless]', CR.Subtypes__full)\|where=C.CardType IN ('Companion', 'Ally', 'Minion')\|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}}\|existing values only\|placeholder=Select 1 or more}}}		{{#cargo_query:tables=Cards=C,CardReleases=CR\|join on=C.ID = CR.ID\|fields=IF(CR.Subtypes__full IS NULL, '[Raceless]', CR.Subtypes__full)\|where=C.CardType IN ('Companion', 'Ally', 'Minion')\|format=template\|template=TagFilterOutput\|group by=Subtypes__full\|order by=CASE WHEN CR.Subtypes__full IS NULL THEN 0 ELSE 1 END,CR.Subtypes__full\|no html}}\|existing values only\|placeholder=Select 1 or more}}}

	<span class="heading">Is Item Class</span><small><i> (OR)</i></small>: {{{field\|itemClass\|input type=tokens\|default=\|size=40\|values=		<span class="heading">Is Item Class</span><small><i> (OR)</i></small>: {{{field\|itemClass\|input type=tokens\|default=\|size=40\|values=

Teltura: Hopefully fixing busted advanced search

2024-01-24T17:42:43Z

Hopefully fixing busted advanced search

Teltura: fixing arrow dir capitalization

2023-01-05T03:38:27Z

fixing arrow dir capitalization

← Older revision		Revision as of 03:38, 5 January 2023
Line 214:		Line 214:
	<span class="heading">Sanctuary</span>{{{field\|isSanctuary\|input type=radiobutton\|default=any\|values=any,yes,no\|size=40}}}		<span class="heading">Sanctuary</span>{{{field\|isSanctuary\|input type=radiobutton\|default=any\|values=any,yes,no\|size=40}}}

	<span class="heading">Arrow Direction</span>{{{field\|arrowDir\|input type=radiobutton\|default=~~Any~~\|values=~~Any~~,~~Left~~,~~Right~~\|size=40}}}		<span class="heading">Arrow Direction</span>{{{field\|arrowDir\|input type=radiobutton\|default=any\|values=any,left,right\|size=40}}}
	</div>		</div>
	</div>		</div>

Teltura: adding sorting for PC formats

2022-11-20T11:40:11Z

adding sorting for PC formats

← Older revision		Revision as of 11:40, 20 November 2022
Line 13:		Line 13:
	{{{for template\|CardSearch}}}		{{{for template\|CardSearch}}}

	<span class="heading">Format: </span>{{{field\|format\|input type=dropdown\|default=\|size=40\|values={{#cargo_query:tables=Formats=F\|fields=F.Name\|order by=CASE WHEN F.Name = "Fellowship ~~Block~~" THEN 1 WHEN F.Name = "Movie ~~Block~~" THEN 2 WHEN F.Name = "Expanded" THEN 3 WHEN F.Name LIKE "Towers%" THEN 4 WHEN F.Name = "King Standard" THEN 5 WHEN F.Name = "King Block" THEN 6 WHEN F.Name LIKE "War of the Ring%" THEN 7 WHEN F.Name = "Standard" THEN 8 ELSE 9 END, F.Name\|format=list\|no html}}\|existing values only\|placeholder=Select 1}}}		<span class="heading">Format: </span>{{{field\|format\|input type=dropdown\|default=\|size=40\|values={{#cargo_query:tables=Formats=F\|fields=F.Name\|order by=CASE WHEN F.Name LIKE "%Fellowship%" THEN 1 WHEN F.Name LIKE "%Movie%" THEN 2 WHEN F.Name LIKE "%Expanded%" THEN 3 WHEN F.Name LIKE "Towers%" THEN 4 WHEN F.Name = "King Standard" THEN 5 WHEN F.Name = "King Block" THEN 6 WHEN F.Name LIKE "War of the Ring%" THEN 7 WHEN F.Name = "Standard" THEN 8 ELSE 9 END, F.Name\|format=list\|no html}}\|existing values only\|placeholder=Select 1}}}

	<div class="flex">		<div class="flex">

Phallen Cassidy: Substantial rearrangement

2022-11-19T06:08:11Z

Substantial rearrangement

Show changes

Teltura at 04:03, 22 October 2022

2022-10-22T04:03:18Z

← Older revision		Revision as of 04:03, 22 October 2022
Line 28:		Line 28:
	<span class="heading">Creator: </span>{{{field\|creator\|input type=tokens\|default=Decipher,Player's Council\|size=40\|values={{#cargo_query:tables=CardSets=S\|fields=S.Creator\|where=S.Creator NOT IN ('mLOTRO', 'Aradrissar')\|group by=S.Creator\|order by=CASE WHEN S.Creator = 'Decipher' THEN 0 WHEN S.Creator = "Player's Council" THEN 1 ELSE 2 END, S.Creator\|format=list\|no html}}\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Creator: </span>{{{field\|creator\|input type=tokens\|default=Decipher,Player's Council\|size=40\|values={{#cargo_query:tables=CardSets=S\|fields=S.Creator\|where=S.Creator NOT IN ('mLOTRO', 'Aradrissar')\|group by=S.Creator\|order by=CASE WHEN S.Creator = 'Decipher' THEN 0 WHEN S.Creator = "Player's Council" THEN 1 ELSE 2 END, S.Creator\|format=list\|no html}}\|existing values only\|placeholder=Select 1 or more}}}

	<span class="heading">Format: </span>{{{field\|format\|input type=dropdown\|default=\|size=40\|values={{#cargo_query:tables=Formats=F\|fields=F.Name\|order by=CASE WHEN F.Name = "Fellowship Block" THEN 1 WHEN F.Name = "Movie Block" THEN 2 WHEN F.Name = "Expanded" THEN 3 WHEN F.Name LIKE "Towers%" THEN 4 WHEN F.Name = "King Standard" THEN 5 WHEN F.Name = "King Block" THEN 6 WHEN F.Name LIKE "War of the Ring%" THEN 7 WHEN F.Name = "Standard" THEN 8 ELSE 9 END, F.Name\|format=list\|~~nohtml~~}}\|existing values only\|placeholder=Select 1}}}		<span class="heading">Format: </span>{{{field\|format\|input type=dropdown\|default=\|size=40\|values={{#cargo_query:tables=Formats=F\|fields=F.Name\|order by=CASE WHEN F.Name = "Fellowship Block" THEN 1 WHEN F.Name = "Movie Block" THEN 2 WHEN F.Name = "Expanded" THEN 3 WHEN F.Name LIKE "Towers%" THEN 4 WHEN F.Name = "King Standard" THEN 5 WHEN F.Name = "King Block" THEN 6 WHEN F.Name LIKE "War of the Ring%" THEN 7 WHEN F.Name = "Standard" THEN 8 ELSE 9 END, F.Name\|format=list\|no html}}\|existing values only\|placeholder=Select 1}}}

	<span class="heading">Set#: </span>{{{field\|setnums\|input type=tokens\|default=\|size=40\|values=1 - The Fellowship of the Ring,2 - Mines of Moria,3 - Realms of the Elf-lords,4 - The Two Towers,5 - Battle of Helm's Deep,6 - Ents of Fangorn,7 - The Return of the King,8 - Siege of Gondor,9 - Reflections,10 - Mount Doom,11 - Shadows,12 - Black Rider,13 - Bloodlines,14 - Expanded Middle-earth, 15 - The Hunters, 16 - The Wraith Collection, 17 - Rise of Saruman, 18 - Treachery & Deceit,19 - Age's End,V1 - Shadow of the Past\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Set#: </span>{{{field\|setnums\|input type=tokens\|default=\|size=40\|values=1 - The Fellowship of the Ring,2 - Mines of Moria,3 - Realms of the Elf-lords,4 - The Two Towers,5 - Battle of Helm's Deep,6 - Ents of Fangorn,7 - The Return of the King,8 - Siege of Gondor,9 - Reflections,10 - Mount Doom,11 - Shadows,12 - Black Rider,13 - Bloodlines,14 - Expanded Middle-earth, 15 - The Hunters, 16 - The Wraith Collection, 17 - Rise of Saruman, 18 - Treachery & Deceit,19 - Age's End,V1 - Shadow of the Past\|existing values only\|placeholder=Select 1 or more}}}

Teltura at 04:02, 22 October 2022

2022-10-22T04:02:52Z

← Older revision		Revision as of 04:02, 22 October 2022
Line 13:		Line 13:
	{{{for template\|CardSearch}}}		{{{for template\|CardSearch}}}

	{{#cargo_query:tables=Formats=F\|fields=F.Name\|order by=CASE WHEN F.Name = "Fellowship Block" THEN 1 WHEN F.Name = "Movie Block" THEN 2 WHEN F.Name = "Expanded" THEN 3 WHEN F.Name LIKE "Towers%" THEN 4 WHEN F.Name = "King Standard" THEN 5 WHEN F.Name = "King Block" THEN 6 WHEN F.Name LIKE "War of the Ring%" THEN 7 WHEN F.Name = "Standard" THEN 8 ELSE 9 END, F.Name\|format=list\|nohtml}}
	~~{{#cargo_query:tables=Formats=F\|fields=F.Name\|format=list\|nohtml}}~~

	<div class="flex">		<div class="flex">
Line 30:		Line 28:
	<span class="heading">Creator: </span>{{{field\|creator\|input type=tokens\|default=Decipher,Player's Council\|size=40\|values={{#cargo_query:tables=CardSets=S\|fields=S.Creator\|where=S.Creator NOT IN ('mLOTRO', 'Aradrissar')\|group by=S.Creator\|order by=CASE WHEN S.Creator = 'Decipher' THEN 0 WHEN S.Creator = "Player's Council" THEN 1 ELSE 2 END, S.Creator\|format=list\|no html}}\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Creator: </span>{{{field\|creator\|input type=tokens\|default=Decipher,Player's Council\|size=40\|values={{#cargo_query:tables=CardSets=S\|fields=S.Creator\|where=S.Creator NOT IN ('mLOTRO', 'Aradrissar')\|group by=S.Creator\|order by=CASE WHEN S.Creator = 'Decipher' THEN 0 WHEN S.Creator = "Player's Council" THEN 1 ELSE 2 END, S.Creator\|format=list\|no html}}\|existing values only\|placeholder=Select 1 or more}}}

	<span class="heading">Format: </span>{{{field\|format\|input type=dropdown\|default=\|size=40\|values={{#cargo_query:tables=Formats=F\|fields=F.Name\|format=list\|~~no html~~}}\|existing values only\|placeholder=Select 1}}}		<span class="heading">Format: </span>{{{field\|format\|input type=dropdown\|default=\|size=40\|values={{#cargo_query:tables=Formats=F\|fields=F.Name\|order by=CASE WHEN F.Name = "Fellowship Block" THEN 1 WHEN F.Name = "Movie Block" THEN 2 WHEN F.Name = "Expanded" THEN 3 WHEN F.Name LIKE "Towers%" THEN 4 WHEN F.Name = "King Standard" THEN 5 WHEN F.Name = "King Block" THEN 6 WHEN F.Name LIKE "War of the Ring%" THEN 7 WHEN F.Name = "Standard" THEN 8 ELSE 9 END, F.Name\|format=list\|nohtml}}\|existing values only\|placeholder=Select 1}}}

	<span class="heading">Set#: </span>{{{field\|setnums\|input type=tokens\|default=\|size=40\|values=1 - The Fellowship of the Ring,2 - Mines of Moria,3 - Realms of the Elf-lords,4 - The Two Towers,5 - Battle of Helm's Deep,6 - Ents of Fangorn,7 - The Return of the King,8 - Siege of Gondor,9 - Reflections,10 - Mount Doom,11 - Shadows,12 - Black Rider,13 - Bloodlines,14 - Expanded Middle-earth, 15 - The Hunters, 16 - The Wraith Collection, 17 - Rise of Saruman, 18 - Treachery & Deceit,19 - Age's End,V1 - Shadow of the Past\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Set#: </span>{{{field\|setnums\|input type=tokens\|default=\|size=40\|values=1 - The Fellowship of the Ring,2 - Mines of Moria,3 - Realms of the Elf-lords,4 - The Two Towers,5 - Battle of Helm's Deep,6 - Ents of Fangorn,7 - The Return of the King,8 - Siege of Gondor,9 - Reflections,10 - Mount Doom,11 - Shadows,12 - Black Rider,13 - Bloodlines,14 - Expanded Middle-earth, 15 - The Hunters, 16 - The Wraith Collection, 17 - Rise of Saruman, 18 - Treachery & Deceit,19 - Age's End,V1 - Shadow of the Past\|existing values only\|placeholder=Select 1 or more}}}

Teltura at 04:02, 22 October 2022

2022-10-22T04:02:18Z

← Older revision		Revision as of 04:02, 22 October 2022
Line 30:		Line 30:
	<span class="heading">Creator: </span>{{{field\|creator\|input type=tokens\|default=Decipher,Player's Council\|size=40\|values={{#cargo_query:tables=CardSets=S\|fields=S.Creator\|where=S.Creator NOT IN ('mLOTRO', 'Aradrissar')\|group by=S.Creator\|order by=CASE WHEN S.Creator = 'Decipher' THEN 0 WHEN S.Creator = "Player's Council" THEN 1 ELSE 2 END, S.Creator\|format=list\|no html}}\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Creator: </span>{{{field\|creator\|input type=tokens\|default=Decipher,Player's Council\|size=40\|values={{#cargo_query:tables=CardSets=S\|fields=S.Creator\|where=S.Creator NOT IN ('mLOTRO', 'Aradrissar')\|group by=S.Creator\|order by=CASE WHEN S.Creator = 'Decipher' THEN 0 WHEN S.Creator = "Player's Council" THEN 1 ELSE 2 END, S.Creator\|format=list\|no html}}\|existing values only\|placeholder=Select 1 or more}}}

	<span class="heading">Format: </span>{{{field\|format\|input type=dropdown\|default=\|size=40\|values={{#cargo_query:tables=Formats=F\|fields=F.Name\|format=list}}\|existing values only\|placeholder=Select 1}}}		<span class="heading">Format: </span>{{{field\|format\|input type=dropdown\|default=\|size=40\|values={{#cargo_query:tables=Formats=F\|fields=F.Name\|format=list\|no html}}\|existing values only\|placeholder=Select 1}}}

	<span class="heading">Set#: </span>{{{field\|setnums\|input type=tokens\|default=\|size=40\|values=1 - The Fellowship of the Ring,2 - Mines of Moria,3 - Realms of the Elf-lords,4 - The Two Towers,5 - Battle of Helm's Deep,6 - Ents of Fangorn,7 - The Return of the King,8 - Siege of Gondor,9 - Reflections,10 - Mount Doom,11 - Shadows,12 - Black Rider,13 - Bloodlines,14 - Expanded Middle-earth, 15 - The Hunters, 16 - The Wraith Collection, 17 - Rise of Saruman, 18 - Treachery & Deceit,19 - Age's End,V1 - Shadow of the Past\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Set#: </span>{{{field\|setnums\|input type=tokens\|default=\|size=40\|values=1 - The Fellowship of the Ring,2 - Mines of Moria,3 - Realms of the Elf-lords,4 - The Two Towers,5 - Battle of Helm's Deep,6 - Ents of Fangorn,7 - The Return of the King,8 - Siege of Gondor,9 - Reflections,10 - Mount Doom,11 - Shadows,12 - Black Rider,13 - Bloodlines,14 - Expanded Middle-earth, 15 - The Hunters, 16 - The Wraith Collection, 17 - Rise of Saruman, 18 - Treachery & Deceit,19 - Age's End,V1 - Shadow of the Past\|existing values only\|placeholder=Select 1 or more}}}

← Older revision		Revision as of 02:28, 25 January 2024
Line 26:		Line 26:

	<span class="heading">Is Race</span><small><i> (OR)</i></small>: {{{field\|race\|input type=tokens\|default=\|size=40\|values=		<span class="heading">Is Race</span><small><i> (OR)</i></small>: {{{field\|race\|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, '[Raceless]', CR.Subtypes__full)\|where=C.CardType IN ('Companion', 'Ally', 'Minion')\|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}}\|existing values only\|placeholder=Select 1 or more}}}		{{#cargo_query:tables=Cards=C,CardReleases=CR\|join on=C.ID = CR.ID\|fields=IF(CR.Subtypes__full IS NULL, '[Raceless]', CR.Subtypes__full)\|where=C.CardType IN ('Companion', 'Ally', 'Minion')\|format=template\|template=TagFilterOutput\|group by=Subtypes__full\|order by=CASE WHEN CR.Subtypes__full IS NULL THEN 0 ELSE 1 END,CR.Subtypes__full\|no html}}\|existing values only\|placeholder=Select 1 or more}}}

	<span class="heading">Is Item Class</span><small><i> (OR)</i></small>: {{{field\|itemClass\|input type=tokens\|default=\|size=40\|values=		<span class="heading">Is Item Class</span><small><i> (OR)</i></small>: {{{field\|itemClass\|input type=tokens\|default=\|size=40\|values=

← Older revision		Revision as of 04:03, 22 October 2022
Line 28:		Line 28:
	<span class="heading">Creator: </span>{{{field\|creator\|input type=tokens\|default=Decipher,Player's Council\|size=40\|values={{#cargo_query:tables=CardSets=S\|fields=S.Creator\|where=S.Creator NOT IN ('mLOTRO', 'Aradrissar')\|group by=S.Creator\|order by=CASE WHEN S.Creator = 'Decipher' THEN 0 WHEN S.Creator = "Player's Council" THEN 1 ELSE 2 END, S.Creator\|format=list\|no html}}\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Creator: </span>{{{field\|creator\|input type=tokens\|default=Decipher,Player's Council\|size=40\|values={{#cargo_query:tables=CardSets=S\|fields=S.Creator\|where=S.Creator NOT IN ('mLOTRO', 'Aradrissar')\|group by=S.Creator\|order by=CASE WHEN S.Creator = 'Decipher' THEN 0 WHEN S.Creator = "Player's Council" THEN 1 ELSE 2 END, S.Creator\|format=list\|no html}}\|existing values only\|placeholder=Select 1 or more}}}

	<span class="heading">Format: </span>{{{field\|format\|input type=dropdown\|default=\|size=40\|values={{#cargo_query:tables=Formats=F\|fields=F.Name\|order by=CASE WHEN F.Name = "Fellowship Block" THEN 1 WHEN F.Name = "Movie Block" THEN 2 WHEN F.Name = "Expanded" THEN 3 WHEN F.Name LIKE "Towers%" THEN 4 WHEN F.Name = "King Standard" THEN 5 WHEN F.Name = "King Block" THEN 6 WHEN F.Name LIKE "War of the Ring%" THEN 7 WHEN F.Name = "Standard" THEN 8 ELSE 9 END, F.Name\|format=list\|~~nohtml~~}}\|existing values only\|placeholder=Select 1}}}		<span class="heading">Format: </span>{{{field\|format\|input type=dropdown\|default=\|size=40\|values={{#cargo_query:tables=Formats=F\|fields=F.Name\|order by=CASE WHEN F.Name = "Fellowship Block" THEN 1 WHEN F.Name = "Movie Block" THEN 2 WHEN F.Name = "Expanded" THEN 3 WHEN F.Name LIKE "Towers%" THEN 4 WHEN F.Name = "King Standard" THEN 5 WHEN F.Name = "King Block" THEN 6 WHEN F.Name LIKE "War of the Ring%" THEN 7 WHEN F.Name = "Standard" THEN 8 ELSE 9 END, F.Name\|format=list\|no html}}\|existing values only\|placeholder=Select 1}}}

	<span class="heading">Set#: </span>{{{field\|setnums\|input type=tokens\|default=\|size=40\|values=1 - The Fellowship of the Ring,2 - Mines of Moria,3 - Realms of the Elf-lords,4 - The Two Towers,5 - Battle of Helm's Deep,6 - Ents of Fangorn,7 - The Return of the King,8 - Siege of Gondor,9 - Reflections,10 - Mount Doom,11 - Shadows,12 - Black Rider,13 - Bloodlines,14 - Expanded Middle-earth, 15 - The Hunters, 16 - The Wraith Collection, 17 - Rise of Saruman, 18 - Treachery & Deceit,19 - Age's End,V1 - Shadow of the Past\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Set#: </span>{{{field\|setnums\|input type=tokens\|default=\|size=40\|values=1 - The Fellowship of the Ring,2 - Mines of Moria,3 - Realms of the Elf-lords,4 - The Two Towers,5 - Battle of Helm's Deep,6 - Ents of Fangorn,7 - The Return of the King,8 - Siege of Gondor,9 - Reflections,10 - Mount Doom,11 - Shadows,12 - Black Rider,13 - Bloodlines,14 - Expanded Middle-earth, 15 - The Hunters, 16 - The Wraith Collection, 17 - Rise of Saruman, 18 - Treachery & Deceit,19 - Age's End,V1 - Shadow of the Past\|existing values only\|placeholder=Select 1 or more}}}

← Older revision		Revision as of 04:02, 22 October 2022
Line 13:		Line 13:
	{{{for template\|CardSearch}}}		{{{for template\|CardSearch}}}

	{{#cargo_query:tables=Formats=F\|fields=F.Name\|order by=CASE WHEN F.Name = "Fellowship Block" THEN 1 WHEN F.Name = "Movie Block" THEN 2 WHEN F.Name = "Expanded" THEN 3 WHEN F.Name LIKE "Towers%" THEN 4 WHEN F.Name = "King Standard" THEN 5 WHEN F.Name = "King Block" THEN 6 WHEN F.Name LIKE "War of the Ring%" THEN 7 WHEN F.Name = "Standard" THEN 8 ELSE 9 END, F.Name\|format=list\|nohtml}}
	~~{{#cargo_query:tables=Formats=F\|fields=F.Name\|format=list\|nohtml}}~~

	<div class="flex">		<div class="flex">
Line 30:		Line 28:
	<span class="heading">Creator: </span>{{{field\|creator\|input type=tokens\|default=Decipher,Player's Council\|size=40\|values={{#cargo_query:tables=CardSets=S\|fields=S.Creator\|where=S.Creator NOT IN ('mLOTRO', 'Aradrissar')\|group by=S.Creator\|order by=CASE WHEN S.Creator = 'Decipher' THEN 0 WHEN S.Creator = "Player's Council" THEN 1 ELSE 2 END, S.Creator\|format=list\|no html}}\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Creator: </span>{{{field\|creator\|input type=tokens\|default=Decipher,Player's Council\|size=40\|values={{#cargo_query:tables=CardSets=S\|fields=S.Creator\|where=S.Creator NOT IN ('mLOTRO', 'Aradrissar')\|group by=S.Creator\|order by=CASE WHEN S.Creator = 'Decipher' THEN 0 WHEN S.Creator = "Player's Council" THEN 1 ELSE 2 END, S.Creator\|format=list\|no html}}\|existing values only\|placeholder=Select 1 or more}}}

	<span class="heading">Format: </span>{{{field\|format\|input type=dropdown\|default=\|size=40\|values={{#cargo_query:tables=Formats=F\|fields=F.Name\|format=list\|~~no html~~}}\|existing values only\|placeholder=Select 1}}}		<span class="heading">Format: </span>{{{field\|format\|input type=dropdown\|default=\|size=40\|values={{#cargo_query:tables=Formats=F\|fields=F.Name\|order by=CASE WHEN F.Name = "Fellowship Block" THEN 1 WHEN F.Name = "Movie Block" THEN 2 WHEN F.Name = "Expanded" THEN 3 WHEN F.Name LIKE "Towers%" THEN 4 WHEN F.Name = "King Standard" THEN 5 WHEN F.Name = "King Block" THEN 6 WHEN F.Name LIKE "War of the Ring%" THEN 7 WHEN F.Name = "Standard" THEN 8 ELSE 9 END, F.Name\|format=list\|nohtml}}\|existing values only\|placeholder=Select 1}}}

	<span class="heading">Set#: </span>{{{field\|setnums\|input type=tokens\|default=\|size=40\|values=1 - The Fellowship of the Ring,2 - Mines of Moria,3 - Realms of the Elf-lords,4 - The Two Towers,5 - Battle of Helm's Deep,6 - Ents of Fangorn,7 - The Return of the King,8 - Siege of Gondor,9 - Reflections,10 - Mount Doom,11 - Shadows,12 - Black Rider,13 - Bloodlines,14 - Expanded Middle-earth, 15 - The Hunters, 16 - The Wraith Collection, 17 - Rise of Saruman, 18 - Treachery & Deceit,19 - Age's End,V1 - Shadow of the Past\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Set#: </span>{{{field\|setnums\|input type=tokens\|default=\|size=40\|values=1 - The Fellowship of the Ring,2 - Mines of Moria,3 - Realms of the Elf-lords,4 - The Two Towers,5 - Battle of Helm's Deep,6 - Ents of Fangorn,7 - The Return of the King,8 - Siege of Gondor,9 - Reflections,10 - Mount Doom,11 - Shadows,12 - Black Rider,13 - Bloodlines,14 - Expanded Middle-earth, 15 - The Hunters, 16 - The Wraith Collection, 17 - Rise of Saruman, 18 - Treachery & Deceit,19 - Age's End,V1 - Shadow of the Past\|existing values only\|placeholder=Select 1 or more}}}

← Older revision		Revision as of 02:30, 25 January 2024
Line 29:		Line 29:

	<span class="heading">Is Item Class</span><small><i> (OR)</i></small>: {{{field\|itemClass\|input type=tokens\|default=\|size=40\|values=		<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]', CR.Subtypes__full)\|where=C.CardType IN ('Artifact', 'Possession') AND (CR.Subtypes__full IS NULL OR 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}}\|existing values only\|placeholder=Select 1 or more}}}		{{#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 IS NULL OR CR.Subtypes__full NOT LIKE '%,%') \|format=template\|template=TagFilterOutput\|group by=Subtypes__full\|order by=CASE WHEN CR.Subtypes__full IS NULL THEN 0 ELSE 1 END,CR.Subtypes__full\|no html}}\|existing values only\|placeholder=Select 1 or more}}}

	<span class="heading">Phase Action</span><small><i> (OR)</i></small>: {{{field\|phaseAction\|input type=tokens\|default=\|size=40\|values=Fellowship,Shadow,Maneuver,Archery,Skirmish,Regroup,Response\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Phase Action</span><small><i> (OR)</i></small>: {{{field\|phaseAction\|input type=tokens\|default=\|size=40\|values=Fellowship,Shadow,Maneuver,Archery,Skirmish,Regroup,Response\|existing values only\|placeholder=Select 1 or more}}}
Line 156:		Line 156:

	<span class="heading">Uses Race</span><small><i> (OR)</i></small>: {{{field\|usesRace\|input type=tokens\|default=\|size=40\|values=		<span class="heading">Uses Race</span><small><i> (OR)</i></small>: {{{field\|usesRace\|input type=tokens\|default=\|size=40\|values=
	{{#cargo_query:tables=Cards=C,CardReleases=CR\|join on=C.ID = CR.ID\|fields=CR.Subtypes__full\|where=C.CardType IN ('Companion', 'Ally', 'Minion') AND CR.Subtypes__full IS NOT NULL\|format=~~list~~\|group by=Subtypes__full\|no html}}\|existing values only\|placeholder=Select 1 or more}}}		{{#cargo_query:tables=Cards=C,CardReleases=CR\|join on=C.ID = CR.ID\|fields=CR.Subtypes__full\|where=C.CardType IN ('Companion', 'Ally', 'Minion') AND CR.Subtypes__full IS NOT NULL\|format=template\|template=TagFilterOutput\|group by=Subtypes__full\|no html}}\|existing values only\|placeholder=Select 1 or more}}}

	<span class="heading">Uses Item Class</span><small><i> (OR)</i></small>: {{{field\|usesItemClass\|input type=tokens\|default=\|size=40\|values=		<span class="heading">Uses Item Class</span><small><i> (OR)</i></small>: {{{field\|usesItemClass\|input type=tokens\|default=\|size=40\|values=
	{{#cargo_query:tables=Cards=C,CardReleases=CR\|join on=C.ID = CR.ID\|fields=CR.Subtypes__full\|where=C.CardType IN ('Artifact', 'Possession') AND CR.Subtypes__full IS NOT NULL AND CR.Subtypes__full NOT LIKE '%,%' AND CR.Subtypes__full NOT LIKE '%Support Area%'\|format=~~list~~\|group by=Subtypes__full\|no html}}\|existing values only\|placeholder=Select 1 or more}}}		{{#cargo_query:tables=Cards=C,CardReleases=CR\|join on=C.ID = CR.ID\|fields=CR.Subtypes__full\|where=C.CardType IN ('Artifact', 'Possession') AND CR.Subtypes__full IS NOT NULL AND CR.Subtypes__full NOT LIKE '%,%' AND CR.Subtypes__full NOT LIKE '%Support Area%'\|format=template\|template=TagFilterOutput\|group by=Subtypes__full\|no html}}\|existing values only\|placeholder=Select 1 or more}}}

	<span class="heading">Uses Keyword</span><small><i> (OR)</i></small>: {{{field\|usesKeyword\|input type=tokens\|default=\|size=40\|values=Ambush,Archer,Battleground,Besieger,Corsair,Damage,Defender,Dwelling,Easterling,Enduring,Engine,Fierce,Forest,Fortification,Hunter,Knight,Lurker,Machine,Marsh,Mountain,Mounted,Muster,Pipeweed,Plains,Ranger,Ring-bound,River,Roaming,Sanctuary,Search,Southron,Spell,Stealth,Tale,Tentacle,Toil,Tracker,Twilight,Unbound,Underground,Unhasty,Valiant,Villager,Warg-rider,Weather,Burglar,Cunning,Wise\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Uses Keyword</span><small><i> (OR)</i></small>: {{{field\|usesKeyword\|input type=tokens\|default=\|size=40\|values=Ambush,Archer,Battleground,Besieger,Corsair,Damage,Defender,Dwelling,Easterling,Enduring,Engine,Fierce,Forest,Fortification,Hunter,Knight,Lurker,Machine,Marsh,Mountain,Mounted,Muster,Pipeweed,Plains,Ranger,Ring-bound,River,Roaming,Sanctuary,Search,Southron,Spell,Stealth,Tale,Tentacle,Toil,Tracker,Twilight,Unbound,Underground,Unhasty,Valiant,Villager,Warg-rider,Weather,Burglar,Cunning,Wise\|existing values only\|placeholder=Select 1 or more}}}
Line 226:		Line 226:
	<span class="heading">Set#: </span>{{{field\|setnums\|input type=tokens\|default=\|size=40\|values=1 - The Fellowship of the Ring,2 - Mines of Moria,3 - Realms of the Elf-lords,4 - The Two Towers,5 - Battle of Helm's Deep,6 - Ents of Fangorn,7 - The Return of the King,8 - Siege of Gondor,9 - Reflections,10 - Mount Doom,11 - Shadows,12 - Black Rider,13 - Bloodlines,14 - Expanded Middle-earth, 15 - The Hunters, 16 - The Wraith Collection, 17 - Rise of Saruman, 18 - Treachery & Deceit,19 - Age's End,V1 - Shadow of the Past\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Set#: </span>{{{field\|setnums\|input type=tokens\|default=\|size=40\|values=1 - The Fellowship of the Ring,2 - Mines of Moria,3 - Realms of the Elf-lords,4 - The Two Towers,5 - Battle of Helm's Deep,6 - Ents of Fangorn,7 - The Return of the King,8 - Siege of Gondor,9 - Reflections,10 - Mount Doom,11 - Shadows,12 - Black Rider,13 - Bloodlines,14 - Expanded Middle-earth, 15 - The Hunters, 16 - The Wraith Collection, 17 - Rise of Saruman, 18 - Treachery & Deceit,19 - Age's End,V1 - Shadow of the Past\|existing values only\|placeholder=Select 1 or more}}}

	<span class="heading">Rarity: </span>{{{field\|rarityabbr\|input type=tokens\|default=\|size=40\|values={{#cargo_query:tables=Rarities=R\|fields=CONCAT(R.Name, ' (', R.Abbr, ')')\|where=R.Sets HOLDS NOT '30' AND R.Sets HOLDS NOT '31'\|order by=R.SortOrder\|format=~~list~~\|no html\|delimiter=,}}\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Rarity: </span>{{{field\|rarityabbr\|input type=tokens\|default=\|size=40\|values={{#cargo_query:tables=Rarities=R\|fields=CONCAT(R.Name, ' (', R.Abbr, ')')\|where=R.Sets HOLDS NOT '30' AND R.Sets HOLDS NOT '31'\|order by=R.SortOrder\|format=template\|template=TagFilterOutput\|no html\|delimiter=,}}\|existing values only\|placeholder=Select 1 or more}}}

	<span class="heading">Foil Images</span>{{{field\|isFoil\|input type=radiobutton\|mandatory\|default=no\|values=yes,no\|size=40}}}		<span class="heading">Foil Images</span>{{{field\|isFoil\|input type=radiobutton\|mandatory\|default=no\|values=yes,no\|size=40}}}

← Older revision		Revision as of 17:42, 24 January 2024
Line 26:		Line 26:

	<span class="heading">Is Race</span><small><i> (OR)</i></small>: {{{field\|race\|input type=tokens\|default=\|size=40\|values=		<span class="heading">Is Race</span><small><i> (OR)</i></small>: {{{field\|race\|input type=tokens\|default=\|size=40\|values=
	~~{{#replace:{{#replace:~~{{#cargo_query:tables=Cards=C,CardReleases=CR\|join on=C.ID = CR.ID\|fields=IF(CR.Subtypes__full IS NULL, '[Raceless]', CR.Subtypes__full)\|where=C.CardType IN ('Companion', 'Ally', 'Minion')\|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>\|~~}}\|existing values only\|placeholder=Select 1 or more}}}		{{#cargo_query:tables=Cards=C,CardReleases=CR\|join on=C.ID = CR.ID\|fields=IF(CR.Subtypes__full IS NULL, '[Raceless]', CR.Subtypes__full)\|where=C.CardType IN ('Companion', 'Ally', 'Minion')\|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}}\|existing values only\|placeholder=Select 1 or more}}}

	<span class="heading">Is Item Class</span><small><i> (OR)</i></small>: {{{field\|itemClass\|input type=tokens\|default=\|size=40\|values=		<span class="heading">Is Item Class</span><small><i> (OR)</i></small>: {{{field\|itemClass\|input type=tokens\|default=\|size=40\|values=
	~~{{#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 IS NULL OR 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>\|~~}}\|existing values only\|placeholder=Select 1 or more}}}		{{#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 IS NULL OR 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}}\|existing values only\|placeholder=Select 1 or more}}}

	<span class="heading">Phase Action</span><small><i> (OR)</i></small>: {{{field\|phaseAction\|input type=tokens\|default=\|size=40\|values=Fellowship,Shadow,Maneuver,Archery,Skirmish,Regroup,Response\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Phase Action</span><small><i> (OR)</i></small>: {{{field\|phaseAction\|input type=tokens\|default=\|size=40\|values=Fellowship,Shadow,Maneuver,Archery,Skirmish,Regroup,Response\|existing values only\|placeholder=Select 1 or more}}}
Line 156:		Line 156:

	<span class="heading">Uses Race</span><small><i> (OR)</i></small>: {{{field\|usesRace\|input type=tokens\|default=\|size=40\|values=		<span class="heading">Uses Race</span><small><i> (OR)</i></small>: {{{field\|usesRace\|input type=tokens\|default=\|size=40\|values=
	~~{{#replace:{{#replace:~~{{#cargo_query:tables=Cards=C,CardReleases=CR\|join on=C.ID = CR.ID\|fields=CR.Subtypes__full\|where=C.CardType IN ('Companion', 'Ally', 'Minion') AND CR.Subtypes__full IS NOT NULL\|format=list\|group by=Subtypes__full\|no html~~}}\|<p>\|}}\|</p>\|~~}}\|existing values only\|placeholder=Select 1 or more}}}		{{#cargo_query:tables=Cards=C,CardReleases=CR\|join on=C.ID = CR.ID\|fields=CR.Subtypes__full\|where=C.CardType IN ('Companion', 'Ally', 'Minion') AND CR.Subtypes__full IS NOT NULL\|format=list\|group by=Subtypes__full\|no html}}\|existing values only\|placeholder=Select 1 or more}}}

	<span class="heading">Uses Item Class</span><small><i> (OR)</i></small>: {{{field\|usesItemClass\|input type=tokens\|default=\|size=40\|values=		<span class="heading">Uses Item Class</span><small><i> (OR)</i></small>: {{{field\|usesItemClass\|input type=tokens\|default=\|size=40\|values=
	~~{{#replace:{{#replace:~~{{#cargo_query:tables=Cards=C,CardReleases=CR\|join on=C.ID = CR.ID\|fields=CR.Subtypes__full\|where=C.CardType IN ('Artifact', 'Possession') AND CR.Subtypes__full IS NOT NULL AND CR.Subtypes__full NOT LIKE '%,%' AND CR.Subtypes__full NOT LIKE '%Support Area%'\|format=list\|group by=Subtypes__full\|no html~~}}\|<p>\|}}\|</p>\|~~}}\|existing values only\|placeholder=Select 1 or more}}}		{{#cargo_query:tables=Cards=C,CardReleases=CR\|join on=C.ID = CR.ID\|fields=CR.Subtypes__full\|where=C.CardType IN ('Artifact', 'Possession') AND CR.Subtypes__full IS NOT NULL AND CR.Subtypes__full NOT LIKE '%,%' AND CR.Subtypes__full NOT LIKE '%Support Area%'\|format=list\|group by=Subtypes__full\|no html}}\|existing values only\|placeholder=Select 1 or more}}}

	<span class="heading">Uses Keyword</span><small><i> (OR)</i></small>: {{{field\|usesKeyword\|input type=tokens\|default=\|size=40\|values=Ambush,Archer,Battleground,Besieger,Corsair,Damage,Defender,Dwelling,Easterling,Enduring,Engine,Fierce,Forest,Fortification,Hunter,Knight,Lurker,Machine,Marsh,Mountain,Mounted,Muster,Pipeweed,Plains,Ranger,Ring-bound,River,Roaming,Sanctuary,Search,Southron,Spell,Stealth,Tale,Tentacle,Toil,Tracker,Twilight,Unbound,Underground,Unhasty,Valiant,Villager,Warg-rider,Weather,Burglar,Cunning,Wise\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Uses Keyword</span><small><i> (OR)</i></small>: {{{field\|usesKeyword\|input type=tokens\|default=\|size=40\|values=Ambush,Archer,Battleground,Besieger,Corsair,Damage,Defender,Dwelling,Easterling,Enduring,Engine,Fierce,Forest,Fortification,Hunter,Knight,Lurker,Machine,Marsh,Mountain,Mounted,Muster,Pipeweed,Plains,Ranger,Ring-bound,River,Roaming,Sanctuary,Search,Southron,Spell,Stealth,Tale,Tentacle,Toil,Tracker,Twilight,Unbound,Underground,Unhasty,Valiant,Villager,Warg-rider,Weather,Burglar,Cunning,Wise\|existing values only\|placeholder=Select 1 or more}}}
Line 226:		Line 226:
	<span class="heading">Set#: </span>{{{field\|setnums\|input type=tokens\|default=\|size=40\|values=1 - The Fellowship of the Ring,2 - Mines of Moria,3 - Realms of the Elf-lords,4 - The Two Towers,5 - Battle of Helm's Deep,6 - Ents of Fangorn,7 - The Return of the King,8 - Siege of Gondor,9 - Reflections,10 - Mount Doom,11 - Shadows,12 - Black Rider,13 - Bloodlines,14 - Expanded Middle-earth, 15 - The Hunters, 16 - The Wraith Collection, 17 - Rise of Saruman, 18 - Treachery & Deceit,19 - Age's End,V1 - Shadow of the Past\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Set#: </span>{{{field\|setnums\|input type=tokens\|default=\|size=40\|values=1 - The Fellowship of the Ring,2 - Mines of Moria,3 - Realms of the Elf-lords,4 - The Two Towers,5 - Battle of Helm's Deep,6 - Ents of Fangorn,7 - The Return of the King,8 - Siege of Gondor,9 - Reflections,10 - Mount Doom,11 - Shadows,12 - Black Rider,13 - Bloodlines,14 - Expanded Middle-earth, 15 - The Hunters, 16 - The Wraith Collection, 17 - Rise of Saruman, 18 - Treachery & Deceit,19 - Age's End,V1 - Shadow of the Past\|existing values only\|placeholder=Select 1 or more}}}

	<span class="heading">Rarity: </span>{{{field\|rarityabbr\|input type=tokens\|default=\|size=40\|values=~~{{#replace:{{#replace:~~{{#cargo_query:tables=Rarities=R\|fields=CONCAT(R.Name, ' (', R.Abbr, ')')\|where=R.Sets HOLDS NOT '30' AND R.Sets HOLDS NOT '31'\|order by=R.SortOrder\|format=list\|no html\|delimiter=,~~}}\|<p>\|}}\|</p>\|~~}}\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Rarity: </span>{{{field\|rarityabbr\|input type=tokens\|default=\|size=40\|values={{#cargo_query:tables=Rarities=R\|fields=CONCAT(R.Name, ' (', R.Abbr, ')')\|where=R.Sets HOLDS NOT '30' AND R.Sets HOLDS NOT '31'\|order by=R.SortOrder\|format=list\|no html\|delimiter=,}}\|existing values only\|placeholder=Select 1 or more}}}

	<span class="heading">Foil Images</span>{{{field\|isFoil\|input type=radiobutton\|mandatory\|default=no\|values=yes,no\|size=40}}}		<span class="heading">Foil Images</span>{{{field\|isFoil\|input type=radiobutton\|mandatory\|default=no\|values=yes,no\|size=40}}}