Template:PromoFilter: Difference between revisions
From LOTR-TCG Wiki
(Created page with "<noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards. </noinclude>C.Subset NOT IN ('M', 'A', 'O', 'T', 'J') AND (C.SetNum <> 0...") |
No edit summary |
||
(4 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
<noinclude>This is used in various cargo queries to | <noinclude>This is used in various cargo queries to filter out promo-only copies of cards. | ||
</noinclude>C.Subset NOT IN ('M', 'A', 'O', 'T', 'J') AND (C.SetNum <> 0 OR C.CardNum IN (56, 57, 58, 59, 60, 62, 63, 64, 65, 66, 67) | List of types filtered out of the results: | ||
* M (Oversized) | |||
* A (Alternate Art Reprints, especially RF) | |||
* O (Masterworks) | |||
* T (Tournament Foil) | |||
* J (Joke cards) | |||
* W (World's Apart Digital) | |||
* L (World's Apart Customizable League Cards) | |||
</noinclude>C.Subset NOT IN ('M', 'A', 'O', 'T', 'J') AND (C.SetNum <> '0' OR C.Subset IN ('W', 'L') OR C.CardNum IN (56, 57, 58, 59, 60, 62, 63, 64, 65, 66, 67)) |
Latest revision as of 01:56, 21 January 2023
This is used in various cargo queries to filter out promo-only copies of cards.
List of types filtered out of the results:
- M (Oversized)
- A (Alternate Art Reprints, especially RF)
- O (Masterworks)
- T (Tournament Foil)
- J (Joke cards)
- W (World's Apart Digital)
- L (World's Apart Customizable League Cards)
C.Subset NOT IN ('M', 'A', 'O', 'T', 'J') AND (C.SetNum <> '0' OR C.Subset IN ('W', 'L') OR C.CardNum IN (56, 57, 58, 59, 60, 62, 63, 64, 65, 66, 67))