Content added Content deleted
(convert all units using cargo; removed various group) |
mNo edit summary |
||
Line 97:
tables=Songs
|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' AND NOT (Songs.unit HOLDS 'Other')
|order by=Songs.song_id ASC
|format=ul
Line 107:
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
Line 117:
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
Line 127:
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
Line 137:
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
|