User:ChaoticShadow/sandbox/8: Difference between revisions

From Sekaipedia
Content added Content deleted
mNo edit summary
mNo edit summary
 
(14 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{ #invoke:Chart | bar chart
{{{!}} style="display:inline-table; padding:5px;"
| height = 750
! colspan="3" style="height:25px; border-radius:6px; background-color:#FFA900" {{!}} Hard Preview
| width = 500
{{!}}-
| stack = 1
! rowspan="7" {{!}} <youtube width="320" height="180">BfO7ceHcMW4</youtube>
| group 1 = 1: 1: 1: 1
{{!}}-
| group 2 = 3: 3: 2: 2
! style="width:100px; border-radius:6px; background-color:#ffd071" {{!}} Release Date
| group 3 = 2: 3: 3: 2
{{!}} style="width:90px" {{!}} 2021/08/18
| group 4 = 5: 4: 5: 5
{{!}}-
| group 5 = 0: 0: 1: 0
{{!}} colspan="5" {{!}} <br><br><br><br><br>
| 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:
<div style="display: inline-block">
tables=Cards
<div style="border-radius:6px; background-color:#FFA900; font-weight: bold; text-align: center; margin-bottom: 5px; padding: 1px">Hard Preview</div>
|fields=COUNT(Cards.card_id)
<div style="display:flex; flex-wrap:wrap; gap: 5px">
|where=card_id > 0 AND card_character = 'Hoshino Ichika'
<div style="flex: 1 0 1px; text-align: center;"><youtube width="320" height="180">BfO7ceHcMW4</youtube></div>
|group by=Cards.rarity
<div style="display:grid; grid-template-columns: 1fr 1fr; grid-auto-rows: min-content; gap: 5px">
|order by=Cards.rarity ASC
<div style="border-radius:6px; background-color:#a7ee75; padding: 5px 10px">Release Date</div>
|format=list
<div style="padding: 5px">2021/08/18</div>
|delimiter=:
<div style="border-radius:6px; background-color:#a7ee75; padding: 5px 10px">Illust</div>
}}
<div style="padding: 5px">Sidu</div>

<div style="border-radius:6px; background-color:#a7ee75; padding: 5px 10px">Movie</div>
{{#cargo_query:
<div style="padding: 5px">Lye</div>
tables=Cards
</div>
|fields=COUNT(Cards.card_id)
</div>
|where=card_id > 0 AND card_character = 'Tenma Saki'
</div>
|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
}}

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".
Error: No database table exists named "Cards".
Error: No database table exists named "Cards".


Error: No database table exists named "Cards".
Error: No database table exists named "Cards".
Cookies help us deliver our services. By using our services, you agree to our use of cookies.