Template:CounterAll: Difference between revisions
From YGOCounter
No edit summary |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 12: | Line 12: | ||
<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-header-multi sortable sticky-table-col2 hover-highlight defaultcenter col2left" style='font-size:90%' | {| 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="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" | | ! class="unsortable" | | ||
| Line 23: | Line 23: | ||
! class="unsortable" |{{Card image|Ghost Ogre & Snow Rabbit}} | ! class="unsortable" |{{Card image|Ghost Ogre & Snow Rabbit}} | ||
! class="unsortable" |{{Card image|Ghost Belle & Haunted Mansion}} | ! class="unsortable" |{{Card image|Ghost Belle & Haunted Mansion}} | ||
! class="unsortable" |{{Card image|Called by the Grave}} | |||
! class="unsortable" |{{Card image|Bystial}} | ! class="unsortable" |{{Card image|Bystial}} | ||
! class="unsortable" |{{Card image|D.D. Crow}} | ! class="unsortable" |{{Card image|D.D. Crow}} | ||
| Line 35: | Line 36: | ||
! class="unsortable" |{{Card image|Super Polymerization}} | ! class="unsortable" |{{Card image|Super Polymerization}} | ||
! class="unsortable" |{{Card image|Lightning Storm}} | ! class="unsortable" |{{Card image|Lightning Storm}} | ||
! class="unsortable" |{{Card image|Evenly | ! class="unsortable" |{{Card image|Evenly Matched}} | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Counter, Deck | tables=Counter, Deck | ||
| Line 61: | Line 62: | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Ghost Belle & Haunted Mansion' THEN Counter.Impact END) = IMPACT7, | 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 = ' | 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 = ' | 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 = 'Evenly | 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 = 'Evenly | 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' | |where=Deck.Tier='Meta' OR Deck.Tier='Rogue' | ||
|group by=Deck._pageTitle | |group by=Deck._pageTitle | ||