More actions
Content deleted Content added
moved last score |
convert all units using cargo; removed various group |
||
Line 16:
|group1 = Original songs <br> (Without SEKAI ver.)
|list1 =
{{#cargo_query:
tables=Songs
|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
|where=Songs.commissioned = '0' AND Songs.contest_winner = '0' 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.')
|order by=Songs.song_id ASC
|format=ul
}}
|group2 = Original songs <br> (With SEKAI ver.)
Line 88 ⟶ 60:
|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
}}
}}
Line 126 ⟶ 84:
|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
}}
|group2 = Leo/need
Line 193 ⟶ 155:
|group4 = Contest winner songs
|list4 =
{{#cargo_query:
tables=Songs
|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
|where=Songs.contest_winner = '1' AND Songs.song_id > '0'
|order by=Songs.song_id ASC
|format=ul
}}
}}<!--
|