Toggle search
Toggle menu
4K
22.1K
2.7K
108.6K
Sekaipedia
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

Template:VIRTUAL SINGER songs: Difference between revisions

Template page
More actions
Content added Content deleted
VisualWikitext
(removing leo need)
m (removed og unit)
Line 14: Line 14:
* [[:Category:VIRTUAL SINGER songs]]
* [[:Category:VIRTUAL SINGER songs]]


|group1 = Original songs <br> (Without SEKAI ver.)
|group1 = Original songs
|list1 =
|list1 =
{{#cargo_query:
{{#cargo_query:
Line 24: Line 24:
}}
}}


|group2 = Original songs <br> (With SEKAI ver.)
|group2 = Commissioned songs
|list2 =
|list2 =
{{Navbox|child

|group2 = MORE MORE JUMP!
|list2 =
{{#cargo_query:
{{#cargo_query:
tables=Songs
tables=Songs
|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
|where=Songs.commissioned = '0' AND Songs.unit HOLDS 'VIRTUAL SINGER' AND Songs.unit HOLDS 'MORE MORE JUMP!' AND Songs.song_id > '0'
|where=Songs.commissioned = '1' AND Songs.unit HOLDS 'VIRTUAL SINGER' AND Songs.song_id > '0' AND NOT (Songs.unit HOLDS 'Leo/need' OR Songs.unit HOLDS 'MORE MORE JUMP!' OR Songs.unit HOLDS 'Vivid BAD SQUAD' OR Songs.unit HOLDS 'Wonderlands×Showtime' OR Songs.unit HOLDS '25-ji, Nightcord de.' OR Songs.unit HOLDS 'Other')
|order by=Songs.song_id ASC
|order by=Songs.song_id ASC
|format=ul
|format=ul
}}
}}


|group3 = Vivid BAD SQUAD
|group3 = Contest winner songs
|list3 =
{{#cargo_query:
tables=Songs
|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
|where=Songs.commissioned = '0' AND Songs.unit HOLDS 'VIRTUAL SINGER' AND Songs.unit HOLDS 'Vivid BAD SQUAD' AND Songs.song_id > '0'
|order by=Songs.song_id ASC
|format=ul
}}

|group4 = Wonderlands×Showtime
|list4 =
{{#cargo_query:
tables=Songs
|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
|where=Songs.commissioned = '0' AND Songs.unit HOLDS 'VIRTUAL SINGER' AND Songs.unit HOLDS 'Wonderlands×Showtime' AND Songs.song_id > '0'
|order by=Songs.song_id ASC
|format=ul
}}

|group5 = 25-ji, Nightcord de.
|list5 =
{{#cargo_query:
tables=Songs
|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
|where=Songs.commissioned = '0' AND Songs.unit HOLDS 'VIRTUAL SINGER' AND Songs.unit HOLDS '25-ji, Nightcord de.' AND Songs.song_id > '0'
|order by=Songs.song_id ASC
|format=ul
}}
}}

|group3 = Commissioned songs
|list3 =
|list3 =
{{Navbox|child
|group1 = VIRTUAL SINGER
|list1 =
{{#cargo_query:
tables=Songs
|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
|where=Songs.commissioned = '1' AND Songs.unit HOLDS 'VIRTUAL SINGER' AND Songs.song_id > '0' AND NOT (Songs.unit HOLDS 'Leo/need' OR Songs.unit HOLDS 'MORE MORE JUMP!' OR Songs.unit HOLDS 'Vivid BAD SQUAD' OR Songs.unit HOLDS 'Wonderlands×Showtime' OR Songs.unit HOLDS '25-ji, Nightcord de.' OR Songs.unit HOLDS 'Other')
|order by=Songs.song_id ASC
|format=ul
}}

|group3 = MORE MORE JUMP!
|list3 =
{{#cargo_query:
tables=Songs
|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
|where=Songs.commissioned = '1' AND Songs.unit HOLDS 'VIRTUAL SINGER' AND Songs.unit HOLDS 'MORE MORE JUMP!' AND Songs.song_id > '0' AND NOT (Songs.unit HOLDS 'Other')
|order by=Songs.song_id ASC
|format=ul
}}

|group4 = Vivid BAD SQUAD
|list4 =
{{#cargo_query:
tables=Songs
|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
|where=Songs.commissioned = '1' AND Songs.unit HOLDS 'VIRTUAL SINGER' AND Songs.unit HOLDS 'Vivid BAD SQUAD' AND Songs.song_id > '0' AND NOT (Songs.unit HOLDS 'Other')
|order by=Songs.song_id ASC
|format=ul
}}

|group5 = Wonderlands×Showtime
|list5 =
{{#cargo_query:
tables=Songs
|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
|where=Songs.commissioned = '1' AND Songs.unit HOLDS 'VIRTUAL SINGER' AND Songs.unit HOLDS 'Wonderlands×Showtime' AND Songs.song_id > '0' AND NOT (Songs.unit HOLDS 'Other')
|order by=Songs.song_id ASC
|format=ul
}}

|group6 = 25-ji, Nightcord de.
|list6 =
{{#cargo_query:
tables=Songs
|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
|where=Songs.commissioned = '1' AND Songs.unit HOLDS 'VIRTUAL SINGER' AND Songs.unit HOLDS '25-ji, Nightcord de.' AND Songs.song_id > '0' AND NOT (Songs.unit HOLDS 'Other')
|order by=Songs.song_id ASC
|format=ul
}}

|group7 = Other
|list7 =
{{#cargo_query:
tables=Songs
|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
|where=Songs.commissioned = '1' AND Songs.unit HOLDS 'VIRTUAL SINGER' AND Songs.unit HOLDS 'Other' AND Songs.song_id > '0'
|order by=Songs.song_id ASC
|format=ul
}}
}}

|group4 = Contest winner songs
|list4 =
{{#cargo_query:
{{#cargo_query:
tables=Songs
tables=Songs

Revision as of 09:01, 29 July 2022

Retrieved from "https://www.sekaipedia.org/wiki/Template:VIRTUAL_SINGER_songs?oldid=43693"
Cookies help us deliver our services. By using our services, you agree to our use of cookies.
More information