More actions
Content deleted Content added
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 |