Template:Album gallery: Difference between revisions

no edit summary
No edit summary
No edit summary
 
Line 1: Line 1:
{{#cargo_query:
{{#cargo_query:
tables=albums
tables=albums,releases
|fields=cover=cover,_pageName=pageName
|join on=albums._pageName=releases._pageName
|where=albums.artist="{{{artist|The Smashing Pumpkins}}}"
|fields=cover,albums._pageName=pageName,name
|order by=`released` ASC
|where=albums.artist="{{{artist|The Smashing Pumpkins}}}" AND releases.release_date != '' AND (albums.type HOLDS 'bootleg' OR albums.type HOLDS 'compilation' OR albums.type HOLDS 'demo' OR albums.type HOLDS 'ep' OR albums.type HOLDS 'live' OR albums.type HOLDS 'promotional' OR albums.type HOLDS 'soundtrack' OR albums.type HOLDS LIKE '%tudio' OR albums.type HOLDS 'tribute' OR albums.type HOLDS 'video')
|order by=release_date ASC
|group by=albums.name
|format=gallery
|format=gallery
|mode=packed-overlay
|mode=packed-hover
|show bytes=0
|show bytes=0
|show filename=0
|show filename=0
|show dimensions=0
|show dimensions=0
|alt field=name
|link field=pageName
|link field=pageName
|caption field=name
}}
}}