User:YBamY/sandbox/4: Difference between revisions

From Sekaipedia
Content added Content deleted
VisualWikitext
mNo edit summary
mNo edit summary
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
== Card character statistic ==
{{#cargo_query:
=== VIRTUAL SINGER ===
tables=Cards
* Hatsune Miku: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Hatsune Miku'}}'''
|fields=Cards.card_character,COUNT(*)
* Kagamine Rin: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Kagamine Rin'}}'''
|group by=Cards.card_character
* Kagamine Len: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Kagamine Len'}}'''
|having=COUNT(*) > 2
* Megurine Luka: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Megurine Luka'}}'''
|order by=COUNT(*) DESC
* MEIKO: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'MEIKO'}}'''
|format=bar chart
* KAITO: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'KAITO'}}'''
}}


==Colorfes Cards==
=== Leo/need ===
* Hoshino Ichika: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Hoshino Ichika'}}'''
{{#cargo_query:
* Tenma Saki: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Tenma Saki'}}'''
tables=Cards
* Mochizuki Honami: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Mochizuki Honami'}}'''
|fields=thumbnail, CONCAT("[[",_pageName,"|",card_name,"]]")=card, card_name=card name, _pageName
|where=Cards.banner LIKE "%Colorful Festival%" AND Cards.card_id > '0' AND NOT Cards.event = 'Scramble Fan FESTA!'
* Hinomori Shiho: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Hinomori Shiho'}}'''
|order by=Cards.card_id ASC
|format=gallery
|mode=nolines
|show bytes=0
|show dimensions=0
|show filename=0
|link field=_pageName
}}


=== MORE MORE JUMP! ===
==4☆ Cards==
* Hanasato Minori: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Hanasato Minori'}}'''
{{#cargo_query:
* Kiritani Haruka: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Kiritani Haruka'}}'''
tables=Cards
* Momoi Airi: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Momoi Airi'}}'''
|fields=thumbnail, CONCAT("[[",_pageName,"|",card_name,"]]")=card, card_name=card name, _pageName
|where=Cards.rarity = '4' AND Cards.card_id > '0'
* Hinomori Shizuku: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Hinomori Shizuku'}}'''
|order by=Cards.card_id ASC
|format=gallery
|mode=nolines
|show bytes=0
|show dimensions=0
|show filename=0
|link field=_pageName
|limit=500
}}


=== Vivid BAD SQUAD ===
==3☆ Cards==
* Azusawa Kohane: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Azusawa Kohane'}}'''
{{#cargo_query:
* Shiraishi An: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Shiraishi An'}}'''
tables=Cards
* Shinonome Akito: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Shinonome Akito'}}'''
|fields=thumbnail, CONCAT("[[",_pageName,"|",card_name,"]]")=card, card_name=card name, _pageName
|where=Cards.rarity = '3' AND Cards.card_id > '0'
* Aoyagi Toya: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Aoyagi Toya'}}'''
|order by=Cards.card_id ASC
|format=gallery
|mode=nolines
|show bytes=0
|show dimensions=0
|show filename=0
|link field=_pageName
|limit=500
}}


=== Wonderlands×Showtime ===
==2☆ Cards==
* Tenma Tsukasa: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Tenma Tsukasa'}}'''
{{#cargo_query:
* Otori Emu: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Otori Emu'}}'''
tables=Cards
* Kusanagi Nene: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Kusanagi Nene'}}'''
|fields=thumbnail, CONCAT("[[",_pageName,"|",card_name,"]]")=card, card_name=card name, _pageName
|where=Cards.rarity = '2' AND Cards.card_id > '0'
* Kamishiro Rui: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Kamishiro Rui'}}'''
|order by=Cards.card_id ASC
|format=gallery
|mode=nolines
|show bytes=0
|show dimensions=0
|show filename=0
|link field=_pageName
|limit=500
}}


=== 25-ji, Nightcord de. ===
==1☆ Cards==
* Yoisaki Kanade: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Yoisaki Kanade'}}'''
{{#cargo_query:
* Asahina Mafuyu: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Asahina Mafuyu'}}'''
tables=Cards
* Shinonome Ena: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Shinonome Ena'}}'''
|fields=thumbnail, CONCAT("[[",_pageName,"|",card_name,"]]")=card, card_name=card name, _pageName
|where=Cards.rarity = '1' AND Cards.card_id > '0'
* Akiyama Mizuki: '''{{#cargo_query:tables=Cards|fields=COUNT(*)|where=Cards.card_id >'0' AND Cards.card_character = 'Akiyama Mizuki'}}'''
|order by=Cards.card_id ASC
|format=gallery
|mode=nolines
|show bytes=0
|show dimensions=0
|show filename=0
|link field=_pageName
|limit=500
}}

Latest revision as of 07:36, 28 February 2022

Card character statistic[edit source]

VIRTUAL SINGER[edit source]

  • Hatsune Miku:
    Error: No database table exists named "Cards".
  • Kagamine Rin:
    Error: No database table exists named "Cards".
  • Kagamine Len:
    Error: No database table exists named "Cards".
  • Megurine Luka:
    Error: No database table exists named "Cards".
  • MEIKO:
    Error: No database table exists named "Cards".
  • KAITO:
    Error: No database table exists named "Cards".

Leo/need[edit source]

  • Hoshino Ichika:
    Error: No database table exists named "Cards".
  • Tenma Saki:
    Error: No database table exists named "Cards".
  • Mochizuki Honami:
    Error: No database table exists named "Cards".
  • Hinomori Shiho:
    Error: No database table exists named "Cards".

MORE MORE JUMP![edit source]

  • Hanasato Minori:
    Error: No database table exists named "Cards".
  • Kiritani Haruka:
    Error: No database table exists named "Cards".
  • Momoi Airi:
    Error: No database table exists named "Cards".
  • Hinomori Shizuku:
    Error: No database table exists named "Cards".

Vivid BAD SQUAD[edit source]

  • Azusawa Kohane:
    Error: No database table exists named "Cards".
  • Shiraishi An:
    Error: No database table exists named "Cards".
  • Shinonome Akito:
    Error: No database table exists named "Cards".
  • Aoyagi Toya:
    Error: No database table exists named "Cards".

Wonderlands×Showtime[edit source]

  • Tenma Tsukasa:
    Error: No database table exists named "Cards".
  • Otori Emu:
    Error: No database table exists named "Cards".
  • Kusanagi Nene:
    Error: No database table exists named "Cards".
  • Kamishiro Rui:
    Error: No database table exists named "Cards".

25-ji, Nightcord de.[edit source]

  • Yoisaki Kanade:
    Error: No database table exists named "Cards".
  • Asahina Mafuyu:
    Error: No database table exists named "Cards".
  • Shinonome Ena:
    Error: No database table exists named "Cards".
  • Akiyama Mizuki:
    Error: No database table exists named "Cards".
Retrieved from "https://www.sekaipedia.org/wiki/User:YBamY/sandbox/4?oldid=30816"
Last modified
This page was last edited on 28 February 2022, at 07:36.
Copyright
Content is available under Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) unless otherwise noted.
Cookies help us deliver our services. By using our services, you agree to our use of cookies.
More information