Template:CounterAll: Difference between revisions
From YGOCounter
No edit summary |
No edit summary |
||
| (10 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<noinclude>[[Category:Template]]</noinclude> | <noinclude>[[Category:Template]]</noinclude> | ||
<div class="center" style="width: auto; margin-left: auto; margin-right: auto;"> | <div class="center" style="width: auto; margin-left: auto; margin-right: auto;"> | ||
<div>'''Find how to counter | <div>'''Find how to counter the most popular Meta and Rogue decks: '''</div> | ||
<div><containerfilter /></div> | <div><containerfilter /></div> | ||
<div>[[Deck|Find full list of decks here]]</div> | |||
</div> | </div> | ||
{{sticky table start}} | {{sticky table start}} | ||
{{sticky header}} | |||
{{row hover highlight}} | {{row hover highlight}} | ||
{{Table alignment}} | {{Table alignment}} | ||
{{LinkColorBlack}} | {{LinkColorBlack}} | ||
<div class="d-flex justify-content-cn border border-info rounded"> | <div class="d-flex justify-content-cn border border-info rounded"> | ||
{| class="wikitable sticky- | {| class="wikitable sticky-header-multi sortable sticky-table-col2 hover-highlight defaultcenter col2left" style='font-size:90%' | ||
! | ! !! !!colspan="2"|Search!!SS!!colspan="2"|Negate!!Destroy!!colspan="4"|GY / Banish!!colspan="4"|Lingering!!Spell SS!!Trap!!colspan="2"|Tribute!!colspan="3"|Board Breaker | ||
|- | |||
! class="unsortable" | | |||
!{{diagonal split header|[[Deck]]|[[Card]]}} | !{{diagonal split header|[[Deck]]|[[Card]]}} | ||
! | ! class="unsortable" |{{Card image|Ash Blossom & Joyous Spring}} | ||
! class="unsortable" |{{Card image|Dominus Purge}} | |||
!{{Card image| | ! class="unsortable" |{{Card image|Dominus Impulse}} | ||
!{{Card image| | ! class="unsortable" |{{Card image|Infinite Impermanence}} | ||
!{{Card image|Infinite Impermanence}} | ! class="unsortable" |{{Card image|PSY-Framegear Gamma}} | ||
!{{Card image| | ! class="unsortable" |{{Card image|Ghost Ogre & Snow Rabbit}} | ||
!{{Card image|Ghost Ogre & Snow Rabbit}} | ! class="unsortable" |{{Card image|Ghost Belle & Haunted Mansion}} | ||
!{{Card image| | ! class="unsortable" |{{Card image|Called by the Grave}} | ||
!{{Card image| | ! class="unsortable" |{{Card image|Bystial}} | ||
!{{Card image| | ! class="unsortable" |{{Card image|D.D. Crow}} | ||
!{{Card image|D.D. Crow}} | ! class="unsortable" |{{Card image|Dimension Shifter}} | ||
!{{Card image| | ! class="unsortable" |{{Card image|Artifact Lancea}} | ||
!{{Card image|Maxx "C"}} | ! class="unsortable" |{{Card image|Droll & Lock Bird}} | ||
!{{Card image| | ! class="unsortable" |{{Card image|Maxx "C"}} | ||
!{{Card image| | ! class="unsortable" |{{Card image|Retaliating "C"}} | ||
!{{Card image| | ! class="unsortable" |{{Card image|Red Reboot}} | ||
!{{Card image| | ! class="unsortable" |{{Card image|Nibiru, the Primal Being}} | ||
!{{Card image| | ! class="unsortable" |{{Card image|Kaiju}} | ||
!{{Card image| | ! class="unsortable" |{{Card image|Super Polymerization}} | ||
! class="unsortable" |{{Card image|Lightning Storm}} | |||
! class="unsortable" |{{Card image|Evenly Matched}} | |||
{{#cargo_query: | {{#cargo_query: | ||
tables=Counter, Deck | tables=Counter, Deck | ||
|join on=Deck._pageTitle = Counter.Deck | |join on=Deck._pageTitle = Counter.Deck | ||
|fields=CONCAT('[[', Deck._pageTitle , ']]') = Deck, ANY_VALUE(Deck.FeatureCard) = FeatureCard, | |fields=CONCAT('[[', Deck._pageTitle , ']]') = Deck, ANY_VALUE(Deck.FeatureCard) = FeatureCard, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Ash Blossom & Joyous Spring' THEN CONCAT('[[', Counter.Deck, '/Ash Blossom & Joyous Spring|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL1, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Ash Blossom & Joyous Spring' THEN Counter.Impact END) = IMPACT1, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Dominus Purge' THEN CONCAT('[[', Counter.Deck, '/Dominus Purge|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL2, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Dominus Purge' THEN Counter.Impact END) = IMPACT2, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Dominus Impulse' THEN CONCAT('[[', Counter.Deck, '/Dominus Impulse|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL3, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Dominus Impulse' THEN Counter.Impact END) = IMPACT3, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Infinite Impermanence' THEN CONCAT('[[', Counter.Deck, '/Infinite Impermanence|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL4, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Infinite Impermanence' THEN Counter.Impact END) = IMPACT4, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'PSY-Framegear Gamma' THEN CONCAT('[[', Counter.Deck, '/PSY-Framegear Gamma|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL5, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'PSY-Framegear Gamma' THEN Counter.Impact END) = IMPACT5, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Ghost Ogre & Snow Rabbit' THEN CONCAT('[[', Counter.Deck, '/Ghost Ogre & Snow Rabbit|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL6, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Ghost Ogre & Snow Rabbit' THEN Counter.Impact END) = IMPACT6, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Ghost Belle & Haunted Mansion' THEN CONCAT('[[', Counter.Deck, '/Ghost Belle & Haunted Mansion|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL7, | |||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Ghost Belle & Haunted Mansion' THEN Counter.Impact END) = IMPACT7, | |||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Called by the Grave' THEN CONCAT('[[', Counter.Deck, '/Called by the Grave|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL8, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Called by the Grave' THEN Counter.Impact END) = IMPACT8, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Bystial' THEN CONCAT('[[', Counter.Deck, '/Bystial|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL9, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Bystial' THEN Counter.Impact END) = IMPACT9, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'D.D. Crow' THEN CONCAT('[[', Counter.Deck, '/D.D. Crow|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL10, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'D.D. Crow' THEN Counter.Impact END) = IMPACT10, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Dimension Shifter' THEN CONCAT('[[', Counter.Deck, '/Dimension Shifter|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL11, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Dimension Shifter' THEN Counter.Impact END) = IMPACT11, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Artifact Lancea' THEN CONCAT('[[', Counter.Deck, '/Artifact Lancea|', Counter.Impact, ']]') END) = COL12, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Artifact Lancea' THEN Counter.Impact END) = IMPACT12, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Droll & Lock Bird' THEN CONCAT('[[', Counter.Deck, '/Droll & Lock Bird|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL13, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Droll & Lock Bird' THEN Counter.Impact END) = IMPACT13, | ||
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) = COL14, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Maxx "C"' THEN Counter.Impact END) = | GROUP_CONCAT(CASE WHEN Counter.Card = 'Maxx "C"' THEN Counter.Impact END) = IMPACT14, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Retaliating "C"' THEN CONCAT('[[', Counter.Deck, '/Retaliating "C"|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL15, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Retaliating "C"' THEN Counter.Impact END) = IMPACT15, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Red Reboot' THEN CONCAT('[[', Counter.Deck, '/Red Reboot|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL16, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Red Reboot' THEN Counter.Impact END) = IMPACT16, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Nibiru, the Primal Being' THEN CONCAT('[[', Counter.Deck, '/Nibiru, the Primal Being|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL17, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Nibiru, the Primal Being' THEN Counter.Impact END) = IMPACT17, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Kaiju' THEN CONCAT('[[', Counter.Deck, '/Kaiju|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL18, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Kaiju' THEN Counter.Impact END) = IMPACT18, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Super Polymerization' THEN CONCAT('[[', Counter.Deck, '/Super Polymerization|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL19, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Super Polymerization' THEN Counter.Impact END) = IMPACT19, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Lightning Storm' THEN CONCAT('[[', Counter.Deck, '/Lightning Storm|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL20, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = ' | GROUP_CONCAT(CASE WHEN Counter.Card = 'Lightning Storm' THEN Counter.Impact END) = IMPACT20, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Evenly Matched' THEN CONCAT('[[', Counter.Deck, '/Evenly Matched|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL21, | |||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Evenly Matched' THEN Counter.Impact END) = IMPACT21, | |||
|where=Deck.Tier='Meta' OR Deck.Tier='Rogue' | |||
|group by=Deck._pageTitle | |group by=Deck._pageTitle | ||
|format=template | |format=template | ||