Template:CounterAll: Difference between revisions
From YGOCounter
No edit summary |
No edit summary |
||
| Line 35: | Line 35: | ||
! 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 97: | Line 97: | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Lightning Storm' THEN Counter.Impact END) = IMPACT19, | GROUP_CONCAT(CASE WHEN Counter.Card = 'Lightning Storm' THEN Counter.Impact END) = IMPACT19, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Evenly | GROUP_CONCAT(CASE WHEN Counter.Card = 'Evenly Matched' THEN CONCAT('[[', Counter.Deck, '/Evenly Matched|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL20, | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Evenly | GROUP_CONCAT(CASE WHEN Counter.Card = 'Evenly Matched' THEN Counter.Impact END) = IMPACT20, | ||
|where=Deck.Tier='Meta' OR Deck.Tier='Rogue' | |where=Deck.Tier='Meta' OR Deck.Tier='Rogue' | ||
|group by=Deck._pageTitle | |group by=Deck._pageTitle | ||
