Template:CounterAll: Difference between revisions
From YGOCounter
No edit summary |
No edit summary |
||
| Line 11: | Line 11: | ||
{{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-header-multi sortable sticky-table-col2 hover-highlight defaultcenter col2left" | {| 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!!GY!!colspan="2"|Banish!!colspan="4"|Lingering!!Spell SS!!Trap!!colspan="2"|Tribute!!colspan="3"|Board Breaker | ||
|- | |- | ||
! class="unsortable" | | ! class="unsortable" | | ||
| 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 Match}} | |||
{{#cargo_query: | {{#cargo_query: | ||
tables=Counter, Deck | tables=Counter, Deck | ||
| Line 95: | Line 96: | ||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Lightning Storm' THEN CONCAT('[[', Counter.Deck, '/Lightning Storm|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL19, | GROUP_CONCAT(CASE WHEN Counter.Card = 'Lightning Storm' THEN CONCAT('[[', Counter.Deck, '/Lightning Storm|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL19, | ||
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 Match' THEN CONCAT('[[', Counter.Deck, '/Evenly Match|', IFNULL(Counter.Impact,'TBD'), ']]') END) = COL20, | |||
GROUP_CONCAT(CASE WHEN Counter.Card = 'Evenly Match' 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 | ||
