Template:VIRTUAL SINGER songs: Difference between revisions

Content added Content deleted

VisualWikitext

Inline

Revision as of 08:40, 8 February 2022

@@ Line 16: / Line 16: @@
 |group1 = Original songs <br> (Without SEKAI ver.)
 |list1  =
+{{#cargo_query:
-* [[Tell Your World]]
+tables=Songs
-* [[Next Nest]]
+|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
-* [[Hand in Hand]]
+|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.')
-* [[39 Music!]]
+|order by=Songs.song_id ASC
-* [[Greenlights Serenade]]
+|format=ul
-* [[Melt]]
+}}
-* [[World is Mine]]
-* [[Hatsune Miku no Shoushitsu]]
-* [[Blessing]]
-* [[Bless Your Breath]]
-* [[Gimme×Gimme]]
-* [[Junky Night Town Orchestra]]
-* [[Leia - Remind]]
-* [[on the rocks]]
-* [[Cendrillon 10th Anniversary]]
-* [[Aisarenakute mo Kimi ga Iru]]
-* [[Hibikase]]
-* [[Senbonzakura]]
-* [[Rolling Girl]]
-* [[Ura-omote Lovers]]
-* [[Unknown Mother Goose]]
-* [[ODDS&ENDS]]
-* [[*Hello, Planet.]]
-* [[World's End Dancehall]]
-* [[Miku Miku ni Shite Ageru ♪ 【Shiteyanyo】]]
-* [[Hatsune Miku no Gekishou]]
-* [[TOKIO FUNKA]]
-* [[Dareka no Shinzou ni Nareta Nara]]
-* [[Haikei Doppelganger]]
-* [[Migikata no Chou]]
-* [[Roshin Yuukai]]
-* [[Hatsune Tenchikaibyaku Shinwa]]
-* [[Aku no Musume]]
-* [[Aku no Meshitsukai]]
-* [[Kimiiro Marine Snow]]
 |group2 = Original songs <br> (With SEKAI ver.)
@@ Line 88: / Line 60: @@
   |group4 = Wonderlands×Showtime
   |list4  =
+{{#cargo_query:
-* [[Dappou Rock]]
+tables=Songs
-* [[Miracle Paint]]
+|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
-* [[Buriki no Dance]]
+|where=Songs.commissioned = '0' AND Songs.unit HOLDS 'VIRTUAL SINGER' AND Songs.unit HOLDS 'Wonderlands×Showtime' AND Songs.song_id > '0'
-* [[Sweet Magic]]
+|order by=Songs.song_id ASC
-* [[Dance Robot Dance]]
+|format=ul
-* [[Bouken no Sho ga Kiemashita!]]
+}}
-* [[Oki ni Mesu mama]]
-* [[Positive☆Dance Time]]
-* [[Telecaster B-Boy]]
-* [[KING]]
-* [[fixer]]
   |group5 = 25-ji, Nightcord de.
   |list5  =
+{{#cargo_query:
-* [[Charles]]
+tables=Songs
-* [[Inochi ni Kirawarete iru.]]
+|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
-* [[Hello/How Are You]]
+|where=Songs.commissioned = '0' AND Songs.unit HOLDS 'VIRTUAL SINGER' AND Songs.unit HOLDS '25-ji, Nightcord de.' AND Songs.song_id > '0'
-* [[Jishou Mushoku]]
+|order by=Songs.song_id ASC
-* [[Hitorinbo Envy]]
+|format=ul
-* [[Otome Kaibou]]
+}}
-* [[Totemo Itai Itagaritai]]
-* [[Cutlery]]
-* [[Bocca della Verità]]
-* [[Bitter Choco Decoration]]
-* [[Venom]]
-* [[Villain]]
-* [[Usseewa]]
-  |group6 = Various
-  |list6  =
-* [[Yoru ni Kakeru]]
   }}
@@ Line 126: / Line 84: @@
   |group1 = VIRTUAL SINGER
   |list1 =
+{{#cargo_query:
-* [[magic number]]
+tables=Songs
-* [[MACHINEGUN POEM DOLL]]
+|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
-* [[Saribitotachi no Waltz]]
+|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: / Line 155: @@
 |group4 = Contest winner songs
 |list4  =
+{{#cargo_query:
-* [[alive]]
+tables=Songs
-* [[Brand New Day]]
+|fields=CONCAT("[[",_pageName,"|",song_name,"]]")=song
-* [[Hana o Utau]]
+|where=Songs.contest_winner = '1' AND Songs.song_id > '0'
-* [[Utakata Mirai]]
+|order by=Songs.song_id ASC
-* [[Sou Datta!!]]
+|format=ul
-* [[Sick of House]]
+}}
-* [[Last Score]]
 }}<!--