Template:Album gallery
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