Toggle search
Toggle menu
4.2K
22.8K
2.8K
111.4K
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
(convert all units using cargo; removed various group)
mNo edit summary
Line 97: Line 97:
tables=Songs
tables=Songs
|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
|where=Songs.commissioned = '1' AND Songs.unit HOLDS 'VIRTUAL SINGER' AND Songs.unit HOLDS 'Leo/need' AND Songs.song_id > '0'
|where=Songs.commissioned = '1' AND Songs.unit HOLDS 'VIRTUAL SINGER' AND Songs.unit HOLDS 'Leo/need' AND Songs.song_id > '0' AND NOT (Songs.unit HOLDS 'Other')
|order by=Songs.song_id ASC
|order by=Songs.song_id ASC
|format=ul
|format=ul
Line 107: Line 107:
tables=Songs
tables=Songs
|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
|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'
|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
|order by=Songs.song_id ASC
|format=ul
|format=ul
Line 117: Line 117:
tables=Songs
tables=Songs
|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
|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'
|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
|order by=Songs.song_id ASC
|format=ul
|format=ul
Line 127: Line 127:
tables=Songs
tables=Songs
|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
|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'
|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
|order by=Songs.song_id ASC
|format=ul
|format=ul
Line 137: Line 137:
tables=Songs
tables=Songs
|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
|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'
|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
|order by=Songs.song_id ASC
|format=ul
|format=ul

Revision as of 08:43, 8 February 2022

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