Cargo query
From LOTR-TCG Wiki
Showing below up to 73 results in range #101 to #173.
{{#cargo_query:
tables=Formats=F,Cards=C,CardReleases=EN,CardReleases=CR,CardSets=S,Languages=L
|fields=CONCAT('[[Image:Culture_', C.Culture, '.svg|x20px|text-bottom|link=', C.Culture, '_Culture|class=whitebg]]', ' <span class="tooltip">[[', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''), '|', CASE WHEN CR.LanguageCode <> 'EN' THEN CONCAT("'''", CR.LanguageCode, "''' ") ELSE '' END, IFNULL(CR.Title,EN.Title), CASE WHEN IFNULL(CR.Subtitle,EN.Subtitle) IS NULL THEN '' ELSE CONCAT(', ', IFNULL(CR.Subtitle,EN.Subtitle)) END, ' (', IFNULL(CR.CollInfo,C.CollInfo), ')', CASE WHEN CR.Revision > 0 THEN CONCAT(' [E',CR.Revision,']') ELSE '' END, ']]<span>[[File:', IFNULL(CR.ImageFilename,'Card_Not_Found.jpg'), '|500x500px]]</span></span>')=CardName
|where=('any' = 'any' OR CR.IsUnique = CASE WHEN 'any' = 'yes' THEN 1 WHEN 'any' = 'no' THEN 0 ELSE 2 END)
AND ("" = "" OR C.Title RLIKE "")
AND ("" = "" OR C.Subtitle RLIKE "")
AND ("Shadow" = "" OR C.Side = "Shadow")
AND ("" = "" OR (F.Name = "" AND ((C.CardType != 'Site' AND F.XList HOLDS NOT C.CollInfo) OR (C.CardType = 'Site' AND CR.Block = F.SitePath))))
AND ("Decipher, Player's Council" = "" OR "Decipher, Player's Council" LIKE CONCAT('%', S.Creator, '%'))
AND ("" = "" OR "" LIKE CONCAT('%', S.Name, '%'))
AND ("" = "" OR "" LIKE CONCAT('%(', C.Rarity, ')%'))
AND ("" = "" OR CR.GameText LIKE "%%")
AND ("" = "" OR CR.GameText RLIKE "")
AND ("" = "" OR "" LIKE CONCAT('%', C.Culture, '%'))
AND ("" = "" OR CR.GameText RLIKE "\\[()]" )
AND ("" = "" OR C.CardType IN (""))
AND ("" = "" OR CR.GameText RLIKE "(?<!this )()" )
AND ("Uruk-hai" = "" OR (C.CardType IN ('Minion', 'Companion', 'Ally') AND ("Uruk-hai" LIKE CONCAT('%', CR.Subtypes__full, '%') OR ("Uruk-hai" = "[Raceless]" AND CR.Subtypes__full IS NULL AND CR.Revision = 0)) ))
AND ("" = "" OR CR.GameText RLIKE "()" OR ("" LIKE '%Dwarf%' AND CR.GameText LIKE '%Dwarves%') OR ("" LIKE '%Elf%' AND CR.GameText LIKE '%Elves%') )
AND ("" = "" OR (C.CardType IN ('Artifact', 'Possession') AND ("" LIKE CONCAT('%', CR.Subtypes__full, '%') OR ("" = "[Classless]" AND CR.Subtypes__full IS NULL AND CR.Revision = 0)) ))
AND ("" = "" OR CR.GameText RLIKE "()" )
AND ("" = "" OR ((C.CardType IN ('Event') AND "" LIKE CONCAT('%', CR.Subtypes__full, '%')) OR CR.GameText RLIKE "(
:)"))
AND ("" = "" OR CR.GameText RLIKE '(?<!\\w )()\\.' OR ("" LIKE '%Ring-bound%' AND (C.Title IN ('Frodo', 'Sam') OR CR.CanBearRing = 1)) OR ("" LIKE '%Unbound%' AND (C.CardType = 'Companion' AND C.Title NOT IN ('Frodo', 'Sam') AND CR.GameText NOT RLIKE '(?<!\\w )Ring-bound\\.')) OR ("" LIKE '%Ambush%' AND CR.GameText RLIKE '(?<!\\w )Ambush \\(\\d+\\)\\.') OR ("" LIKE '%Hunter%' AND CR.GameText RLIKE '(?<!\\w )Hunter \\d+\\.') )
AND ("" = "" OR (CR.GameText RLIKE '(?<=\\w )()' AND (1 = CASE WHEN "" LIKE '%Archer%' AND CR.GameText LIKE '%Archer%' THEN CR.GameText RLIKE '(?<=\\w )archer\\b' ELSE 1 END )) )
AND ("" = "" OR CR.TwilightCost = "")
AND ("" = "" OR CR.TwilightCost >= "")
AND ("" = "" OR CR.TwilightCost <= "")
AND ("" = "" OR CASE WHEN "" RLIKE '(\\+|-)\\d+' THEN CR.StrengthMod = "" ELSE CR.Strength = "" END)
AND ("" = "" OR CASE WHEN "" RLIKE '(\\+|-)\\d+' THEN CAST(CR.StrengthMod AS INT) >= CAST("" AS INT) ELSE CR.Strength >= "" END)
AND ("" = "" OR CASE WHEN "" RLIKE '(\\+|-)\\d+' THEN CAST(CR.StrengthMod AS INT) <= CAST("" AS INT) ELSE CR.Strength <= "" END)
AND ("" = "" OR CASE WHEN "" RLIKE '(\\+|-)\\d+' THEN CR.VitalityMod = "" ELSE CR.Vitality = "" END)
AND ("" = "" OR CASE WHEN "" RLIKE '(\\+|-)\\d+' THEN CAST(CR.VitalityMod AS INT) >= CAST("" AS INT) ELSE CR.Vitality >= "" END)
AND ("" = "" OR CASE WHEN "" RLIKE '(\\+|-)\\d+' THEN CAST(CR.VitalityMod AS INT) <= CAST("" AS INT) ELSE CR.Vitality >= "" END)
AND ("" = "" OR CASE WHEN "" RLIKE '(\\+|-)\\d+' THEN CR.SiteNumMod = "" ELSE CR.SiteNum = "" END)
AND ("" = "" OR CASE WHEN "" RLIKE '(\\+|-)\\d+' THEN CAST(CR.SiteNumMod AS INT) >= CAST("" AS INT) ELSE CR.SiteNum >= "" END)
AND ("" = "" OR CASE WHEN "" RLIKE '(\\+|-)\\d+' THEN CAST(CR.SiteNumMod AS INT) <= CAST("" AS INT) ELSE CR.SiteNum >= "" END)
AND ("" = "" OR CASE WHEN "" RLIKE '(\\+|-)\\d+' THEN CR.ResistanceMod = "" ELSE CR.Resistance = "" END)
AND ("" = "" OR CASE WHEN "" RLIKE '(\\+|-)\\d+' THEN CAST(CR.ResistanceMod AS INT) >= CAST("" AS INT) ELSE CR.Resistance >= "" END)
AND ("" = "" OR CASE WHEN "" RLIKE '(\\+|-)\\d+' THEN CAST(CR.ResistanceMod AS INT) <= CAST("" AS INT) ELSE CR.Resistance >= "" END)
AND ("" = "" OR CR.Signet = "")
AND ("" = "" OR (C.CardType = 'Site' AND CR.SiteNum = ""))
AND ("" = "" OR (C.CardType = 'Site' AND CR.SiteNum >= ""))
AND ("" = "" OR (C.CardType = 'Site' AND CR.SiteNum <= ""))
AND ("" = "" OR (C.CardType = 'Site' AND IFNULL(CR.ShadowNum, CR.TwilightCost) = ""))
AND ("" = "" OR (C.CardType = 'Site' AND IFNULL(CR.ShadowNum, CR.TwilightCost) >= ""))
AND ("" = "" OR (C.CardType = 'Site' AND IFNULL(CR.ShadowNum, CR.TwilightCost) <= ""))
AND ("any" = "any" OR CASE WHEN CASE WHEN 'any' = 'yes' THEN 1 WHEN 'any' = 'no' THEN 0 ELSE 2 END = 1 THEN CR.GameText RLIKE '(?<!\\w )Sanctuary\\.' ELSE CR.GameText NOT RLIKE '(?<!\\w )Sanctuary\\.' END)
AND ("any" = "any" OR CR.ArrowDir = "any")
AND (CASE WHEN CASE WHEN 'no' = 'yes' THEN 1 WHEN 'no' = 'no' THEN 0 ELSE 2 END = 0 THEN CR.Subset NOT IN ('F', 'A', 'O') ELSE CR.Subset IN ('F', 'A', 'O') END)
AND ("any" = "any" OR IFNULL(CR.IsPhysical, C.IsPhysical) = CASE WHEN 'any' = 'yes' THEN 1 WHEN 'any' = 'no' THEN 0 ELSE 2 END)
AND ("yes" = "any" OR IFNULL(CR.isPlayable, C.isPlayable) = CASE WHEN 'yes' = 'yes' THEN 1 WHEN 'yes' = 'no' THEN 0 ELSE 2 END)
AND ("any" = "any" OR CASE WHEN CASE WHEN 'any' = 'yes' THEN 1 WHEN 'any' = 'no' THEN 0 ELSE 2 END = 0 THEN CR.Revision = 0 WHEN CASE WHEN 'any' = 'yes' THEN 1 WHEN 'any' = 'no' THEN 0 ELSE 2 END = 1 THEN CR.Revision > 0 END )
AND ("English" = "" OR L.Name IN ("English"))
AND ("" = "" OR CR.Lore RLIKE "")
AND ("" = "" OR
("" RLIKE '(Burdens:|Auto-corruption)' AND CR.GameText RLIKE 'corrupt') OR
("" RLIKE '(Burdens:|Add Burdens)' AND CR.GameText RLIKE 'add (up to )?(a|X|\\d) burden') OR
("" RLIKE '(Burdens:|Prevent Burden Removal)' AND CR.GameText RLIKE '(burden[^\\.]*(can|may) ?not (be )?remove|about to remove[^\\.]*burdens?,)') OR
("" RLIKE '(Burdens:|Remove Burdens)' AND CR.GameText RLIKE 'remove (up to )?(a|X|\\d) burden') OR
("" RLIKE '(Burdens:|Prevent Burden Adding)' AND CR.GameText RLIKE '(burden[^\\.]*(can|may) ?not (be )?add|about to add[^\\.]*burdens?,)') OR
("" RLIKE '(Burdens:|Spot Burdens)' AND CR.GameText RLIKE '(spot (an?|X|\\d|all|every|each) burden|burden you (can )? spot|\\(or \\d burdens\\)|for each burden)') OR
("" RLIKE '(Stats:|Modify Strength:|Add Strength)' AND CR.GameText RLIKE 'strength (of [^\\d\\.\\+-]* )?\\+') OR
("" RLIKE '(Stats:|Modify Strength:|Remove Strength)' AND CR.GameText RLIKE 'strength (of [^\\d\\.\\+-]* )?-') OR
("" RLIKE '(Stats:|Modify Resistance:|Add Resistance)' AND CR.GameText RLIKE 'resistance (of [^\\d\\.\\+-]* )?\\+') OR
("" RLIKE '(Stats:|Modify Resistance:|Remove Resistance)' AND CR.GameText RLIKE 'resistance (of [^\\d\\.\\+-]* )?-') OR
("" RLIKE '(Stats:|Modify Site Number:|Add Site Number)' AND CR.GameText RLIKE 'site number (of [^\\d\\.\\+-]* )?\\+') OR
("" RLIKE '(Stats:|Modify Site Number:|Remove Site Number)' AND CR.GameText RLIKE 'site number (of [^\\d\\.\\+-]* )?-') OR
("" LIKE '%Ally Removal%' AND (CR.GameText RLIKE 'discard (up to )?(an?|X|\\d|all|every|each) (\\[\\w+\\] )?(\\w+ or )?ally' OR C.CollInfo IN ('8R103'))) OR
("" LIKE '%Companion Removal%' AND CR.GameText RLIKE 'discard (up to )?(an?|X|\\d|all|every|each) (\\[\\w+\\] )?(\\w+ or )?companion(?! from hand)') OR
("" LIKE '%Minion Removal%' AND CR.GameText RLIKE 'discard (up to )?(an?|X|\\d|all|every|each) (\\[\\w+\\] )?(\\w+ or )?minion') OR
("" LIKE '%Follower Removal%' AND (CR.GameText RLIKE 'discard (up to )?(an?|X|\\d|all|every|each) (\\[\\w+\\] )?(\\w+ or )?follower' OR C.CollInfo IN ('4R32', '8R103'))) OR
("" LIKE '%Condition Removal%' AND (CR.GameText RLIKE 'discard (up to )?(an?|X|\\d|all|every|each) (Free Peoples |Shadow )?(\\[\\w+\\] )?(\\w+ or (Free Peoples |Shadow )?)?condition' OR C.CollInfo IN ('4R32', '8R103'))) OR
("" LIKE '%Possession Removal%' AND (CR.GameText RLIKE 'discard (up to )?(an?|X|\\d|all|every|each) (Free Peoples |Shadow )?(\\[\\w+\\] )?(\\w+ or (Free Peoples |Shadow )?)?possession' OR C.CollInfo IN ('4R32', '8R103'))) OR
("" LIKE '%Artifact Removal%' AND (CR.GameText RLIKE 'discard (up to )?(an?|X|\\d|all|every|each) (Free Peoples |Shadow )?(\\[\\w+\\] )?(\\w+ or (Free Peoples |Shadow )?)?artifact' OR C.CollInfo IN ('4R32', '8R103'))) OR
("" RLIKE '(Cycling:|Draw Cards)' AND (CR.GameText RLIKE 'draw (up to )?(an?|X|\\d|all|every|each) card' AND CR.GameText NOT RLIKE 'opponent shuffle[^\\.]*draw deck and draw' AND CR.GameText NOT RLIKE '(Free Peoples |Shadow )?player (must |may )?draw' OR CR.GameText RLIKE 'muster')) OR
("" RLIKE '(Cycling:|Recover Cards Into Hand)' AND CR.GameText RLIKE 'take [^\\.]*into hand') OR
("" RLIKE '(Cycling:|Discard From Your Hand)' AND (CR.GameText RLIKE 'discard [^\\.]*from hand' AND CR.GameText NOT RLIKE '(opponent|owner|(Free Peoples |Shadow )?player)[^\\.]* discard[^\\.]*from hand' OR CR.GameText RLIKE 'muster')) OR
("" RLIKE '(Recursion:|Take Cards Into Hand From Discard)' AND CR.GameText RLIKE 'take [^\\.]*into hand from[^\\.]*discard') OR
("" RLIKE '(Recursion:|Take Cards Into Hand From Deck)' AND CR.GameText RLIKE 'take [^\\.]*into hand from[^\\.]*draw deck') OR
("" RLIKE '(Recursion:|Play Cards From Discard)' AND CR.GameText RLIKE 'play (up to )?(an?|X|\\d|all|every|each) (\\[\\w+\\] )?(Free Peoples |Shadow )?\\w* from your discard pile') OR
("" RLIKE '(Recursion:|Play Cards From Deck)' AND CR.GameText RLIKE 'play (up to )?(an?|X|\\d|all|every|each) (\\[\\w+\\] )?(Free Peoples |Shadow )?\\w* from your draw deck') OR
("" RLIKE '(Skirmishing:|Ally Participation)' AND CR.GameText RLIKE '(participates? in (archery fire and )?skirmish)') OR
("" RLIKE '(Skirmishing:|Cancel Skirmish)' AND CR.GameText RLIKE '(Cancel [^\\.]*skirmish)') OR
("" RLIKE '(Skirmishing:|Dodge Skirmish)' AND (C.CollInfo IN ('4C310','4C314','4C322','17U103','7R129') OR CR.GameText RLIKE '(remove [^\\.]*from a skirmish)')) OR
("" RLIKE '(Skirmishing:|Replace Skirmish)' AND CR.GameText RLIKE 'replace[^\\.]*skirmish') OR
("" RLIKE '(Skirmishing:|Overwhelm Protection)' AND CR.GameText RLIKE '(overwhelmed unless)') OR
("" RLIKE '(Signets:|Uses Aragorn Signet)' AND CR.GameText RLIKE 'Aragorn signet') OR
("" RLIKE '(Signets:|Uses Frodo Signet)' AND CR.GameText RLIKE 'Frodo signet') OR
("" RLIKE '(Signets:|Uses Gandalf Signet)' AND CR.GameText RLIKE 'Gandalf signet') OR
("" RLIKE '(Signets:|Uses Théoden Signet)' AND CR.GameText RLIKE 'Theoden signet') OR
("" RLIKE '(Culture Tokens:|Add Tokens)' AND CR.GameText RLIKE '(add|place|reinforce) (up to )?(an?|X|\\d|all|every|each) (Free Peoples |Shadow )?(\\[\\w+\\] )?(culture )?token') OR
("" RLIKE '(Culture Tokens:|Reinforce Tokens)' AND CR.GameText RLIKE '(reinforce) (up to )?(an?|X|\\d|all|every|each) (Free Peoples |Shadow )?(\\[\\w+\\] )?(culture )?token') OR
("" RLIKE '(Culture Tokens:|Remove Tokens)' AND CR.GameText RLIKE '(remove) (up to )?(an?|X|\\d|all|every|each) (Free Peoples |Shadow )?(\\[\\w+\\] )?(culture )?token') OR
("" RLIKE '(Culture Tokens:|Remove Token From Others)' AND CR.GameText RLIKE '(remove) (up to )?(an?|X|\\d|all|every|each) (Free Peoples |Shadow )?(\\[\\w+\\] )?(culture )?tokens? (?!from here)(?!from this card)(?!here)') OR
("" RLIKE '(Culture Tokens:|Spot Tokens)' AND (CR.GameText RLIKE '(spot) (up to )?(an?|X|\\d|all|every|each) (Free Peoples |Shadow )?(\\[\\w+\\] )?(culture )?tokens? (?!from here)(?!from this card)(?!here)' OR CR.GameText RLIKE 'for each (Free Peoples |Shadow )?(\\[\\w+\\] )?(culture )?tokens? (?!from here)(?!from this card)(?!here)') ) OR
("" RLIKE '(Threats:|Add Threats)' AND CR.GameText RLIKE 'add (up to )?(a|X|\\d) threat') OR
("" RLIKE '(Threats:|Prevent Threat Removal)' AND CR.GameText RLIKE '(threat[^\\.]*(can|may) ?not (be )?remove|about to remove[^\\.]*threats?,)') OR
("" RLIKE '(Threats:|Remove Threats)' AND CR.GameText RLIKE 'remove (up to )?(a|X|\\d) threat') OR
("" RLIKE '(Move Limit:|Increase Move Limit)' AND CR.GameText RLIKE 'move limit (for this turn )?(is )?\\+') OR
("" RLIKE '(Move Limit:|Decrease Move Limit)' AND CR.GameText RLIKE 'move limit (for this turn )?(is )?-') OR
("" RLIKE '(Move Limit:|Force Move)' AND CR.GameText RLIKE 'move again') OR
("" RLIKE '(Move Limit:|Force Stop)' AND CR.GameText RLIKE 'prevent[^\\.]*moving again') OR
("" RLIKE '(Site Manipulation:|Play Site)' AND CR.GameText RLIKE '((play|replace) the fellowship''s|replace it with your site|replace a site)') OR
("" RLIKE '(Site Manipulation:|Prevent Site Replacement)' AND CR.GameText RLIKE 'not (be )?replace') OR
("" RLIKE '(Site Control:|Take Control Of Site)' AND C.Side <> 'Free Peoples' AND CR.GameText RLIKE '(take control|to control)') OR
("" RLIKE '(Site Control:|Liberate Site)' AND CR.GameText RLIKE 'liberate') OR
("" RLIKE '(Site Control:|Prevent Site Control)' AND CR.GameText RLIKE 'about to (take )?control') OR
("" RLIKE '(Site Control:|Your Site Control Bonus)' AND CR.GameText RLIKE '(you control)') OR
("" RLIKE '(Site Control:|No Site Control Bonus)' AND CR.GameText RLIKE '(no opponent control)') OR
("" RLIKE '(Initiative:|Initiative Bonus)' AND CR.GameText RLIKE '((while|if) (you|shadow) (have|has) initiative)') OR
("" RLIKE '(Initiative:|Shadow Initiative Manipulation)' AND CR.GameText RLIKE '((?<!if )(?<!if the )shadow (player )?has initiative|to have initiative)') OR
("" RLIKE '(Initiative:|Freeps Initiative Loss Bonus)' AND C.Side = 'Free Peoples' AND CR.GameText RLIKE '(you lose initiative|shadow has initiative)') OR
("" RLIKE '(Card Manipulation:|Look At Top Of Deck)' AND CR.GameText RLIKE "(look at the top (\\w+ )?cards? of (your|its owners|(your|an) opponent's|his or her|their) draw deck)") OR
("" RLIKE '(Card Manipulation:|Reveal Top Of Deck)' AND CR.GameText RLIKE "(reveal the top (\w+ )?cards? of (your|its owners|(your|an) opponent's|his or her|their) draw deck)") OR
("" RLIKE '(Card Manipulation:|Place On Top Of Deck)' AND CR.GameText RLIKE "(on top of ((or beneath )?your|its owners|(your|an) opponent's|his or her|their) draw deck)") OR
("" RLIKE '(Card Manipulation:|Place On Bottom Of Deck)' AND CR.GameText RLIKE "((on the bottom of|beneath) (your|its owners|(your|an) opponent's|his or her|their) draw deck)") OR
("" RLIKE '(Card Manipulation:|Shuffle Into Deck)' AND CR.GameText RLIKE "shuffle (up to )?(an?|X|\\d|all|every|each)[^\\.]* into (your|its owners|(your|an) opponent's|his or her|their) draw deck") OR
("" RLIKE '(Card Manipulation:|Discard From Your Deck)' AND CR.GameText RLIKE "discards? (up to )?(the|an?|X|\\d|all|every|each)[^\\.]* (from|of) (the top of )?your draw deck") OR
("" RLIKE '(Card Manipulation:|Discard From Opponent''s Deck)' AND CR.GameText RLIKE "discards? (up to )?(the|an?|X|\\d|all|every|each)[^\\.]* (from|of) (the top of )?(its owners|(your|an) opponent's|his|his or her|their) draw deck") OR
("" RLIKE '(Card Manipulation:|Discard From Opponent''s Hand)' AND CR.GameText RLIKE "(discards? (up to )?(an?|X|\\d|all|every|each)[^\\.]* from (its owners|(your|an) opponent's|the shadow player''s|his|his or her|their) hand|((choose|make) )?(an opponent|the shadow player|the free peoples player|that player)( to)? discard[^\\.]*from hand)|owner discards") OR
("" RLIKE '(Card Manipulation:|Reveal Opponent''s Hand)' AND CR.GameText RLIKE "(reveal (up to )?(an?|X|\\d|all|every|each)[^\\.]* from (its owners|(your|an) opponent's|his|his or her|their) hand|reveal (your|an) opponent's hand)") OR
1=0
)
AND 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))
|join on=F.ValidSets HOLDS C.SetNum,C.ReprintBaseID = EN.ID,EN.ID = CR.BaseCardID,C.SetNum=S.ID,CR.LanguageCode=L.Code
|group by=C._pageName, CR.LanguageCode, CR.Subset, CR.Revision
|order by=CASE WHEN C.SetNum = '0' THEN 1 ELSE 0 END, CASE WHEN CAST(C.SetNum AS UNSIGNED INTEGER) < 20 THEN 0 WHEN LEFT(C.SetNum, 1) = 'V' THEN 1 ELSE 2 END, CASE C.Side WHEN 'Free Peoples' THEN 1 WHEN 'Shadow' THEN 2 WHEN 'None' THEN CASE WHEN C.Culture = 'The One Ring' THEN 0 ELSE 3 END ELSE 4 END, CASE WHEN C.Culture = 'The One Ring' THEN 'AAA' WHEN C.Culture = 'Site' THEN 'ZZZ' ELSE C.Culture END, CASE WHEN C.SetNum = '0' THEN 20 ELSE CASE WHEN C.SetNum RLIKE '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.SetNum = '0' THEN CASE WHEN C.Subset IN ('S', 'F') THEN 1 WHEN C.Subset IN ('D', 'L') THEN 2 WHEN C.Subset = 'M' THEN 3 WHEN C.Subset = 'J' THEN 4 ELSE 20 END ELSE CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'M' THEN 2 WHEN C.Subset = 'A' THEN 3 WHEN C.Subset = 'O' THEN 4 WHEN C.Subset = 'T' THEN 5 END END, C.CardNum, CR.Revision
|format=ul
|offset=100
|limit=100
|default=''No Cards Found''
|columns=2
}}
