Difference between revisions of "Template:Featured Cards"
m |
|||
| Line 2: | Line 2: | ||
tables=Cards,Card_Files | tables=Cards,Card_Files | ||
|join on=Cards.number = Card_Files.number | |join on=Cards.number = Card_Files.number | ||
| − | |fields=Card_Files.icon1, CONCAT(Cards.rarity, ' ', Cards.chara) = Caption, CONCAT('Cards/', Cards.chara, '/', Cards.cardname) = Page Link | + | |fields=IFNULL(Card_Files.icon1,Card_Files.icon2), CONCAT(Cards.rarity, ' ', Cards.chara) = Caption, CONCAT('Cards/', Cards.chara, '/', Cards.cardname) = Page Link |
|where=Cards.cardset="{{{1}}}" | |where=Cards.cardset="{{{1}}}" | ||
|order by=Cards.rarity DESC | |order by=Cards.rarity DESC | ||
| Line 8: | Line 8: | ||
|template=Featured Cards/Line}}</includeonly> | |template=Featured Cards/Line}}</includeonly> | ||
<noinclude> | <noinclude> | ||
| − | {{Featured Cards| | + | {{Featured Cards|Dazzling Rose Mansion}} |
</noinclude> | </noinclude> | ||
Latest revision as of 18:03, 27 April 2020
(Elegant Nénuphar) Azuma Yukishiro Action SSR++ Icon Bloomed.png | (Elegant Nénuphar) Azuma Yukishiro Action SSR++ Icon Bloomed.png|SSR++ Azuma Yukishiro|link=Cards/Azuma Yukishiro/Elegant Nénuphar|alt=SSR++ Azuma Yukishiro
(Smiling Fleurir) Tsumugi Tsukioka Comedy SSR Icon Unbloomed.png | (Smiling Fleurir) Tsumugi Tsukioka Comedy SSR Icon Unbloomed.png|SSR Tsumugi Tsukioka|link=Cards/Tsumugi Tsukioka/Smiling Fleurir|alt=SSR Tsumugi Tsukioka
(Warm Jardinage) Kazunari Miyoshi Serious SR Icon Unbloomed.png | (Warm Jardinage) Kazunari Miyoshi Serious SR Icon Unbloomed.png|SR Kazunari Miyoshi|link=Cards/Kazunari Miyoshi/Warm Jardinage|alt=SR Kazunari Miyoshi
(Noble Adult) Homare Arisugawa Action R Icon Unbloomed.png | (Noble Adult) Homare Arisugawa Action R Icon Unbloomed.png|R Homare Arisugawa|link=Cards/Homare Arisugawa/Noble Adult|alt=R Homare Arisugawa
