Cargo query

From LOTR-TCG Wiki

Showing below up to 20 results in range #91 to #110.

View ( | ) (20 | 50 | 100 | 250 | 500)

Signet CardName Culture CardType GameText
Signet CardName Culture CardType GameText

Merry, Unquenchable Hobbit (4R311)

Shire Companion

Skirmish: If Merry is not assigned to a skirmish, discard him to remove a Orc from a skirmish involving an unbound companion.

Pippin, Just a Nuisance (4R313)

Shire Companion

Skirmish: If Pippin is not assigned to a skirmish, discard him to remove an Uruk-hai from a skirmish involving an unbound companion.

Sam, Samwise the Brave (4C316)

Shire Companion

Ring-bound.

Response: If a Shadow card is about to add any number of burdens, spot Frodo and exert Sam to prevent this.

Response: If Frodo is killed, make Sam the Ring-bearer (resistance 5).

Théoden, King of the Golden Hall (5C93)

Rohan Companion

Valiant.

Maneuver: Play a possession on Théoden to heal a ally.

Éowyn, Daughter of Eomund (5P122)

Rohan Companion

Valiant.

Maneuver: Play a possession on Éowyn to heal her.

Éomer, Rohirrim Captain (6R92)

Rohan Companion

Valiant. While you can spot a Man, Éomer’s twilight cost is –1. Skirmish: Discard 3 cards from hand to make a Man strength +2 for each wound on each minion in his or her skirmish.

Faramir, Ithilien Ranger (6P121)

Gondor Companion

Ring-bound. Ranger. If Faramir is in your starting fellowship, his twilight cost is –1. Fellowship: Play a ranger to heal a Ring-bound companion.

Arwen, Fair Elf Maiden (7R16)

Elven Companion

While skirmishing a fierce minion, Arwen is strength +3.

Gandalf, Defender of the West (7C36)

Gandalf Companion

While you cannot spot 3 companions of the same culture, Gandalf is strength –2.

Théoden, Rekindled King (7R255)

Rohan Companion

While you can spot a Man, Théoden’s twilight cost is –1.

Fellowship: If the twilight pool has fewer than 2 twilight tokens, play a possession on Théoden and add to heal another companion.

Merry, Rohirrim Squire (7C320)

Shire Companion

Skirmish: If you cannot spot 3 threats, add a threat to make Merry strength +2.

Pippin, Sworn to Service (7C323)

Shire Companion

While you cannot spot 4 threats, Pippin is strength +1 for each threat you can spot.

Aragorn, Driven by Need (7P364)

Gondor Companion

While you cannot spot 4 threats, Aragorn is strength +1 for each threat.

Regroup: Exert Aragorn twice to remove 3 threats.

Gimli, Counter of Foes (8C5)

Dwarven Companion

Damage +1.

For each wound on Gimli, he is strength +1 and damage +1.

Faramir, Defender of Osgiliath (8C34)

Gondor Companion

Knight.

When you play Faramir (except in your starting fellowship), you may reveal the top 10 cards of your draw deck. You may play a knight revealed. Shuffle your draw deck.

Éomer, Keeper of Oaths (8C87)

Rohan Companion

Valiant. When you play Éomer (except in your starting fellowship), you may reveal the top 10 cards of your draw deck and play all possessions revealed. Shuffle your draw deck.

Radagast, The Brown (9R+26)

Gandalf Companion

The move limit is +1.

Each time the fellowship moves during the regroup phase, each opponent may discard 2 cards from hand to draw 2 cards.

Éowyn, Lady of Ithilien (10R72)

Rohan Companion

Skirmish: Exert Éowyn to choose an opponent. That opponent must wound a minion for each wound on each minion skirmishing Éowyn.

Sam, Great Elf Warrior (10P122)

Shire Companion

Ring-bound.

Sam is strength +1 for each companion you can spot.

Response: If Frodo dies, make Sam the Ring-bearer (resistance 5).

Boromir, Defender of Minas Tirith (12U43)

Gondor Companion

Ranger.

Fellowship: Add to heal Boromir.

View ( | ) (20 | 50 | 100 | 250 | 500)

Modify query

View wikitext
{{#cargo_query:
limit=20
|offset=90
|tables=Cards=C,CardReleases=CR
|fields=CONCAT('[[Image:', CR.Signet, ' Signet Icon.png|x80px|text-bottom]]')=Signet
,CONCAT('<span class="tooltip">[[',  REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),  '|',  CR.Title,  CASE WHEN CR.Subtitle IS NULL THEN '' ELSE CONCAT(', ', CR.Subtitle) END, ' (', IFNULL(CR.CollInfo,C.CollInfo), ')]]<span>[[File:', IFNULL(CR.ImageFilename,'Card_Not_Found.jpg'), ']]</span></span>')=CardName
,C.Culture=Culture
,C.CardType
,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText
|where=C.SetNum <> 0
AND C.CardType = 'Companion'
AND CR.Signet <> 'None'
|join on=C.ID = CR.ID
|order by=CR.Signet, 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 ASC
|format=dynamic table
|rows per page=107
}}