Template:Song list stats: Difference between revisions
MusikAnimal (talk | contribs) (Created page with "{{#cargo_query: tables=songs |fields=COUNT(DISTINCT _ID)=Total songs, COUNT(DISTINCT artist)=Artists, COUNT(DISTINCT main_album)=Albums |where=writer HOLDS "Billy Corgan" }}") |
MusikAnimal (talk | contribs) No edit summary |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=songs | tables=songs | ||
|fields=COUNT(DISTINCT _ID)=Total songs, COUNT(DISTINCT artist)=Artists, COUNT(DISTINCT main_album)=Albums | |fields=COUNT(DISTINCT _ID)=Total songs{{#if:{{{artist|}}}||, COUNT(DISTINCT artist)=Artists}}, COUNT(DISTINCT main_album)=Albums | ||
|where=writer HOLDS " | |where={{#invoke:String|join| AND |{{#if:{{{artist|}}}|artist = "{{{artist}}}" {{#if:{{{original|}}}|AND original_artist IS NULL}}}}|{{#if:{{{writer|}}}|writer HOLDS "{{{writer}}}"}}}} | ||
}} | }} | ||
Latest revision as of 05:45, 3 December 2020
| Total songs | Artists | Albums |
|---|---|---|
| 1,316 | 69 | 117 |