Template:CounterAll: Difference between revisions
From YGOCounter
m 1 revision imported |
No edit summary |
||
| Line 33: | Line 33: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Counter, Deck | tables=Counter, Deck | ||
|join on=Deck. | |join on=Deck._pageTitle = Counter.Deck | ||
|fields=CONCAT('[[', Deck. | |fields=CONCAT('[[', Deck._pageTitle , ']]') = Deck, ANY_VALUE(Deck.FeatureCard) = FeatureCard, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Artifact Lancea' THEN CONCAT('[[', Counter.Deck, '/Artifact Lancea|', IFNULL(Counter.Impact,'TBD'), ']]') END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Artifact Lancea' THEN CONCAT('[[', Counter.Deck, '/Artifact Lancea|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL1, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Artifact Lancea' THEN Counter.Impact END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Artifact Lancea' THEN Counter.Impact END) = IMPACT1, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Ash Blossom & Joyous Spring' THEN CONCAT('[[', Counter.Deck, '/Ash Blossom & Joyous Spring|', IFNULL(Counter.Impact,'TBD'), ']]') END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Ash Blossom & Joyous Spring' THEN CONCAT('[[', Counter.Deck, '/Ash Blossom & Joyous Spring|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL2, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Ash Blossom & Joyous Spring' THEN Counter.Impact END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Ash Blossom & Joyous Spring' THEN Counter.Impact END) = IMPACT2, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Effect Veiler' THEN CONCAT('[[', Counter.Deck, '/Effect Veiler|', IFNULL(Counter.Impact,'TBD'), ']]') END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Effect Veiler' THEN CONCAT('[[', Counter.Deck, '/Effect Veiler|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL3, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Effect Veiler' THEN Counter.Impact END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Effect Veiler' THEN Counter.Impact END) = IMPACT3, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Bystial' THEN CONCAT('[[', Counter.Deck, '/Bystial|', IFNULL(Counter.Impact,'TBD'), ']]') END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Bystial' THEN CONCAT('[[', Counter.Deck, '/Bystial|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL4, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Bystial' THEN Counter.Impact END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Bystial' THEN Counter.Impact END) = IMPACT4, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Infinite Impermanence' THEN CONCAT('[[', Counter.Deck, '/Infinite Impermanence|', IFNULL(Counter.Impact,'TBD'), ']]') END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Infinite Impermanence' THEN CONCAT('[[', Counter.Deck, '/Infinite Impermanence|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL5, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Infinite Impermanence' THEN Counter.Impact END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Infinite Impermanence' THEN Counter.Impact END) = IMPACT5, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Dimension Shifter' THEN CONCAT('[[', Counter.Deck, '/Dimension Shifter|', IFNULL(Counter.Impact,'TBD'), ']]') END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Dimension Shifter' THEN CONCAT('[[', Counter.Deck, '/Dimension Shifter|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL6, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Dimension Shifter' THEN Counter.Impact END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Dimension Shifter' THEN Counter.Impact END) = IMPACT6, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Ghost Ogre & Snow Rabbit' THEN CONCAT('[[', Counter.Deck, '/Ghost Ogre & Snow Rabbit|', IFNULL(Counter.Impact,'TBD'), ']]') END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Ghost Ogre & Snow Rabbit' THEN CONCAT('[[', Counter.Deck, '/Ghost Ogre & Snow Rabbit|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL7, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Ghost Ogre & Snow Rabbit' THEN Counter.Impact END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Ghost Ogre & Snow Rabbit' THEN Counter.Impact END) = IMPACT7, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Nibiru, the Primal Being' THEN CONCAT('[[', Counter.Deck, '/Nibiru, the Primal Being|', IFNULL(Counter.Impact,'TBD'), ']]') END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Nibiru, the Primal Being' THEN CONCAT('[[', Counter.Deck, '/Nibiru, the Primal Being|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL8, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Nibiru, the Primal Being' THEN Counter.Impact END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Nibiru, the Primal Being' THEN Counter.Impact END) = IMPACT8, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'PSY-Framegear Gamma' THEN CONCAT('[[', Counter.Deck, '/PSY-Framegear Gamma|', IFNULL(Counter.Impact,'TBD'), ']]') END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'PSY-Framegear Gamma' THEN CONCAT('[[', Counter.Deck, '/PSY-Framegear Gamma|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL9, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'PSY-Framegear Gamma' THEN Counter.Impact END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'PSY-Framegear Gamma' THEN Counter.Impact END) = IMPACT9, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Droll & Lock Bird' THEN CONCAT('[[', Counter.Deck, '/Droll & Lock Bird|', IFNULL(Counter.Impact,'TBD'), ']]') END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Droll & Lock Bird' THEN CONCAT('[[', Counter.Deck, '/Droll & Lock Bird|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL10, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Droll & Lock Bird' THEN Counter.Impact END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Droll & Lock Bird' THEN Counter.Impact END) = IMPACT10, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'D.D. Crow' THEN CONCAT('[[', Counter.Deck, '/D.D. Crow|', Counter.Impact, ']]') END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'D.D. Crow' THEN CONCAT('[[', Counter.Deck, '/D.D. Crow|', Counter.Impact, ']]') END) = COL11, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'D.D. Crow' THEN Counter.Impact END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'D.D. Crow' THEN Counter.Impact END) = IMPACT11, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Evenly Matched' THEN CONCAT('[[', Counter.Deck, '/Evenly Matched|', IFNULL(Counter.Impact,'TBD'), ']]') END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Evenly Matched' THEN CONCAT('[[', Counter.Deck, '/Evenly Matched|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL12, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Evenly Matched' THEN Counter.Impact END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Evenly Matched' THEN Counter.Impact END) = IMPACT12, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Maxx "C"' THEN CONCAT('[[', Counter.Deck, '/Maxx "C"|', IFNULL(Counter.Impact,'TBD'), ']]') END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Maxx "C"' THEN CONCAT('[[', Counter.Deck, '/Maxx "C"|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL13, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Maxx "C"' THEN Counter.Impact END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Maxx "C"' THEN Counter.Impact END) = IMPACT13, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Ghost Belle & Haunted Mansion' THEN CONCAT('[[', Counter.Deck, '/Ghost Belle & Haunted Mansion|', IFNULL(Counter.Impact,'TBD'), ']]') END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Ghost Belle & Haunted Mansion' THEN CONCAT('[[', Counter.Deck, '/Ghost Belle & Haunted Mansion|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL14, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Ghost Belle & Haunted Mansion' THEN Counter.Impact END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Ghost Belle & Haunted Mansion' THEN Counter.Impact END) = IMPACT14, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Ghost Mourner & Moonlit Chill' THEN CONCAT('[[', Counter.Deck, '/Ghost Mourner & Moonlit Chill|', IFNULL(Counter.Impact,'TBD'), ']]') END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Ghost Mourner & Moonlit Chill' THEN CONCAT('[[', Counter.Deck, '/Ghost Mourner & Moonlit Chill|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL15, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Ghost Mourner & Moonlit Chill' THEN Counter.Impact END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Ghost Mourner & Moonlit Chill' THEN Counter.Impact END) = IMPACT15, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Ghost Sister & Spooky Dogwood' THEN CONCAT('[[', Counter.Deck, '/Ghost Sister & Spooky Dogwood|', IFNULL(Counter.Impact,'TBD'), ']]') END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Ghost Sister & Spooky Dogwood' THEN CONCAT('[[', Counter.Deck, '/Ghost Sister & Spooky Dogwood|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL16, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Ghost Sister & Spooky Dogwood' THEN Counter.Impact END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Ghost Sister & Spooky Dogwood' THEN Counter.Impact END) = IMPACT16, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Kurikara Divincarnate' THEN CONCAT('[[', Counter.Deck, '/Kurikara Divincarnate|', IFNULL(Counter.Impact,'TBD'), ']]') END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Kurikara Divincarnate' THEN CONCAT('[[', Counter.Deck, '/Kurikara Divincarnate|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL17, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Kurikara Divincarnate' THEN Counter.Impact END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Kurikara Divincarnate' THEN Counter.Impact END) = IMPACT17, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Skull Meister' THEN CONCAT('[[', Counter.Deck, '/Skull Meister|', IFNULL(Counter.Impact,'TBD'), ']]') END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Skull Meister' THEN CONCAT('[[', Counter.Deck, '/Skull Meister|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL18, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Skull Meister' THEN Counter.Impact END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Skull Meister' THEN Counter.Impact END) = IMPACT18, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Called by the Grave' THEN CONCAT('[[', Counter.Deck, '/Called by the Grave|', IFNULL(Counter.Impact,'TBD'), ']]') END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Called by the Grave' THEN CONCAT('[[', Counter.Deck, '/Called by the Grave|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL19, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Called by the Grave' THEN Counter.Impact END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Called by the Grave' THEN Counter.Impact END) = IMPACT19, | ||
|group by= | |group by=Deck._pageTitle | ||
|format=template | |format=template | ||
|template=CounterAllRow | |template=CounterAllRow | ||
Revision as of 06:15, 5 January 2026
Find how to counter your opponent: