Template: ListIpName
Query: SELECT `cargo__Component`.`Name` AS `Service`,`cargo__ComponentRN`.`ReleaseNumber` AS `ReleaseNumber`,DATE_FORMAT(MAX(PrivateEditionReleaseDate),'%M %d, %Y') AS `ReleaseDate`,`Containers` AS `Containers`,`ComponentId` AS `ComponentId` FROM `cargo__RNElements` LEFT OUTER JOIN `cargo__ComponentRN` ON ((`cargo__RNElements`.`Version`=`cargo__ComponentRN`.`ReleaseNumber`)) LEFT OUTER JOIN `cargo__Component` ON ((`cargo__ComponentRN`.`ComponentId` HOLDS `cargo__Component`.`Id`)) WHERE `cargo__RNElements`.`IpName`="" AND `cargo__ComponentRN`.`_pageNamespace`="0" AND PrivateEditionReleaseDate IS NOT NULL GROUP BY `cargo__ComponentRN`.`_pageName` ORDER BY `cargo__ComponentRN`.`ReleaseDate` DESC LIMIT 1 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 `cargo__RNElements`.`IpName`="" AND `car' at line 1 (127.0.0.1)