Template:Song list stats: Difference between revisions
MusikAnimal (talk | contribs) m (MusikAnimal moved page Template:Writer song stats to Template:Song list stats without leaving a redirect) |
MusikAnimal (talk | contribs) No edit summary |
||
| (2 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,319 | 69 | 118 |