User:ChaoticShadow/sandbox/8: Difference between revisions

Content added Content deleted

VisualWikitext

Inline

Latest revision as of 09:22, 29 November 2021

3

6

9

12

15

Ichika

Saki

Honami

Shiho

1*
2*
3*
4*
Birthday

Error: No database table exists named "Cards".

@@ Line 1: / Line 1: @@
-{{#invoke:Story Chapter|main
+{{ #invoke:Chart | bar chart
+| height = 750
-|chapter  =  Chapter 1
+| width = 500
-|image    = Stella2020 chapter 1.png
+| stack = 1
-|english  = Under The Rain Alone
+| group 1 = 1: 1: 1: 1
-|japanese = ひとりぼっちの雨模様
+| group 2 = 3: 3: 2: 2
+| group 3 = 2: 3: 3: 2
+| group 4 = 5: 4: 5: 5
+| group 5 = 0: 0: 1: 0
+| colors = turquoise : grey : orange: pink : purple
+| group names = 1* : 2* : 3* : 4* : Birthday
+| x legends = Ichika : Saki : Honami : Shiho
+| y tick marks = 5
 }}
+{{#cargo_query:
-{{#invoke:Story Chapter|main
+tables=Cards
+|fields=COUNT(Cards.card_id)
+|where=card_id > 0 AND card_character = 'Hoshino Ichika'
+|group by=Cards.rarity
+|order by=Cards.rarity ASC
+|format=list
+|delimiter=:
+}}
+{{#cargo_query:
+tables=Cards
+|fields=COUNT(Cards.card_id)
+|where=card_id > 0 AND card_character = 'Tenma Saki'
+|group by=Cards.rarity
+|order by=Cards.rarity ASC
+|format=list
+|delimiter= :
+}}
+{{#cargo_query:
+tables=Cards
+|fields=COUNT(Cards.card_id)
+|where=card_id > 0 AND card_character = 'Mochizuki Honami'
+|group by=Cards.rarity
+|order by=Cards.rarity ASC
+|format=list
+|delimiter= :
+}}
+{{#cargo_query:
+tables=Cards
+|fields=COUNT(Cards.card_id)
+|where=card_id > 0 AND card_character = 'Hinomori Shiho'
+|group by=Cards.rarity
+|order by=Cards.rarity ASC
+|format=list
+|delimiter= :
+}}
+{{#cargo_query:
+tables=Cards
+|fields=Cards.card_character, Cards.rarity, COUNT(Cards.card_character)
+|where=Cards.card_id > 0
+|group by=Cards.card_character, Cards.rarity
+|limit=200
+|format=table
 }}