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 ensure a sensible, generalized ordering of cards.
<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))