3,726
edits
Template:Song list stats: Difference between revisions
no edit summary
MusikAnimal (talk | contribs) No edit summary |
MusikAnimal (talk | contribs) No edit summary |
||
| 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={{#invoke:String|join| AND |{{#if:{{{artist|}}}|artist = "{{{artist}}}" {{#if:{{{original|}}}|AND original_artist IS NULL}}}}|{{#if:{{{writer|}}}|writer HOLDS "{{{writer}}}"}}}} | |where={{#invoke:String|join| AND |{{#if:{{{artist|}}}|artist = "{{{artist}}}" {{#if:{{{original|}}}|AND original_artist IS NULL}}}}|{{#if:{{{writer|}}}|writer HOLDS "{{{writer}}}"}}}} | ||
}} | }} | ||