Template:PromoFilter

From LOTR-TCG Wiki

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))