Template:Album gallery: Difference between revisions

Latest revision as of 16:36, 12 August 2020

Error 1525: Incorrect DATE value:

Function: CargoSQLQuery::run Query: SELECT `cover` AS `cover`,`cargo__albums`.`_pageName` AS `pageName`,`name` AS `name` FROM `cargo__albums` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__albums`.`_pageName`=`cargo__releases`.`_pageName`)) WHERE `cargo__albums`.`artist`="The Smashing Pumpkins" AND `cargo__releases`.`release_date` != AND (`cargo__albums`.`_ID` IN (SELECT `_rowID` FROM `cargo__albums__type` WHERE `_value`= 'bootleg') OR `cargo__albums`.`_ID` IN (SELECT `_rowID` FROM `cargo__albums__type` WHERE `_value`= 'compilation') OR `cargo__albums`.`_ID` IN (SELECT `_rowID` FROM `cargo__albums__type` WHERE `_value`= 'demo') OR `cargo__albums`.`_ID` IN (SELECT `_rowID` FROM `cargo__albums__type` WHERE `_value`= 'ep') OR `cargo__albums`.`_ID` IN (SELECT `_rowID` FROM `cargo__albums__type` WHERE `_value`= 'live') OR `cargo__albums`.`_ID` IN (SELECT `_rowID` FROM `cargo__albums__type` WHERE `_value`= 'promotional') OR `cargo__albums`.`_ID` IN (SELECT `_rowID` FROM `cargo__albums__type` WHERE `_value`= 'soundtrack') OR `cargo__albums`.`_ID` IN (SELECT `_rowID` FROM `cargo__albums__type` WHERE `_value`LIKE '%tudio') OR `cargo__albums`.`_ID` IN (SELECT `_rowID` FROM `cargo__albums__type` WHERE `_value`= 'tribute') OR `cargo__albums`.`_ID` IN (SELECT `_rowID` FROM `cargo__albums__type` WHERE `_value`= 'video') ) GROUP BY `cargo__albums`.`name` ORDER BY `release_date` LIMIT 100

@@ Line 1: / Line 1: @@
 {{#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
-|mode=packed-overlay
+|mode=packed-hover
 |show bytes=0
 |show filename=0
 |show dimensions=0
+|alt field=name
 |link field=pageName
+|caption field=name
 }}