Difference between revisions of "Template: GetContainers"
| Line 21: | Line 21: | ||
|join on=ArticleCloudRN__ComponentId._value=Component.Id,ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID,ArticleCloudRN__ComponentId._value = ComponentRN__ComponentId._value,ComponentRN__ComponentId._rowID=ComponentRN._ID,ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id | |join on=ArticleCloudRN__ComponentId._value=Component.Id,ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID,ArticleCloudRN__ComponentId._value = ComponentRN__ComponentId._value,ComponentRN__ComponentId._rowID=ComponentRN._ID,ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id | ||
|fields=CONCAT('[[',ArticleCloudRN._pageName,'#',DATE_FORMAT(MAX(ReleaseDate),'%M %d, %Y'),'|',DATE_FORMAT(MAX(PrivateEditionReleaseDate),'%M %d, %Y'),']]') | |fields=CONCAT('[[',ArticleCloudRN._pageName,'#',DATE_FORMAT(MAX(ReleaseDate),'%M %d, %Y'),'|',DATE_FORMAT(MAX(PrivateEditionReleaseDate),'%M %d, %Y'),']]') | ||
| − | |where=ComponentRN._pageNamespace=" | + | |where=ComponentRN._pageNamespace="0" AND ArticleCloudRN._pageNamespace="0" AND PrivateEditionReleaseDate IS NOT NULL |
|group by=ComponentRN.ComponentId | |group by=ComponentRN.ComponentId | ||
}} | }} | ||
Revision as of 00:02, April 12, 2022
Query: SELECT `cargo__Component`.`Name` AS `Name` FROM `cargo__ComponentRN` LEFT OUTER JOIN `cargo__Component` ON ((`cargo__ComponentRN`.`ComponentId` HOLDS `cargo__Component`.`Id`)) WHERE ComponentId HOLDS AND PrivateEditionReleaseDate="" AND `cargo__ComponentRN`.`_pageNamespace`="0" GROUP BY `Name` ORDER BY `cargo__Component`.`Name` LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS `cargo__Component`.`Id`)) WHERE ComponentId HOLDS AND PrivateEditionR' at line 1 (127.0.0.1)
Query: SELECT MAX(ReleaseNumber) FROM `cargo__ComponentRN` WHERE ComponentId HOLDS AND PrivateEditionReleaseDate="" AND `cargo__ComponentRN`.`_pageNamespace`="0" ORDER BY MAX(ReleaseNumber) LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS AND PrivateEditionReleaseDate="" AND `cargo__ComponentRN`.`_pageNamespa' at line 1 (127.0.0.1)
October 29, 2021, July 23, 2021, June 30, 2021, April 07, 2022, June 30, 2021, October 18, 2021, October 29, 2021, October 29, 2021, September 14, 2021, July 25, 2022, October 04, 2021, April 07, 2022, June 23, 2022, September 17, 2021, July 07, 2022, May 11, 2022, June 30, 2021, September 15, 2021, February 24, 2022, March 28, 2022, March 28, 2022, March 31, 2022, February 02, 2022, March 28, 2022, May 02, 2022, February 08, 2022, July 08, 2022, July 25, 2022, March 28, 2022, March 28, 2022, September 15, 2021, December 17, 2021, June 30, 2021, October 31, 2021, June 30, 2022, September 30, 2021, February 22, 2022, June 23, 2022, July 07, 2022, September 09, 2021, August 31, 2021, May 24, 2022, February 01, 2022
Query: SELECT `cargo__RNElements`.`Filename` AS `Filename` FROM `cargo__ComponentRN` LEFT OUTER JOIN `cargo__Component` ON ((`cargo__ComponentRN`.`ComponentId` HOLDS `cargo__Component`.`Id`)) LEFT OUTER JOIN `cargo__RNElements` ON ((`cargo__Component`.`IpName`=`cargo__RNElements`.`IpName`)) WHERE `cargo__ComponentRN`.`ComponentId` HOLDS AND PrivateEditionReleaseDate="" AND Type="helm" AND `cargo__ComponentRN`.`_pageNamespace`="0" GROUP BY `cargo__RNElements`.`Version`,`cargo__RNElements`.`Filename` HAVING MAX(`cargo__ComponentRN`.`ReleaseNumber`)=`cargo__RNElements`.`Version` ORDER BY `cargo__RNElements`.`Filename` LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS `cargo__Component`.`Id`)) LEFT OUTER JOIN `cargo__RNElements` ON ((`cargo_' at line 1 (127.0.0.1)