Template:VIRTUAL SINGER songs: Difference between revisions

Content added Content deleted

Inline

Revision as of 13:35, 25 July 2022

@@ Line 27: / Line 27: @@
 |list2  =
   {{Navbox|child
-  |group1 = Leo/need
-  |list1  =
-{{#cargo_query:
-tables=Songs
-|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
-|where=Songs.commissioned = '0' AND Songs.unit HOLDS 'VIRTUAL SINGER' AND Songs.unit HOLDS 'Leo/need' AND Songs.song_id > '0'
-|order by=Songs.song_id ASC
-|format=ul
-}}
   |group2 = MORE MORE JUMP!
@@ Line 88: / Line 78: @@
 |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
-}}
-  |group2 = Leo/need
-  |list2  =
-{{#cargo_query:
-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