Template: PrintTopRN
{{#cargo_query:
table=ComponentRN,DeploymentType |join on=ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id
|intro=
|fields=CONCAT('50px') |delimiter=
|where=ComponentId HOLDS "" AND ReleaseDate="" AND ComponentRN._pageNamespace="10"
Query: SELECT `Highlight` AS `Highlight` FROM `cargo__ComponentRN` LEFT OUTER JOIN `cargo__ComponentRN__DeploymentTypeId` ON ((`cargo__ComponentRN`.`_ID`=`cargo__ComponentRN__DeploymentTypeId`.`_rowID`)) RIGHT OUTER JOIN `cargo__DeploymentType` ON ((`cargo__ComponentRN__DeploymentTypeId`.`_value`=`cargo__DeploymentType`.`Id`)) WHERE ComponentId HOLDS "" AND ReleaseDate="" AND `cargo__ComponentRN`.`_pageNamespace`="10" GROUP BY `Highlight` ORDER BY `Highlight` 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 ReleaseDate="" AND `cargo__ComponentRN`.`_pageNamespace`="10" GROU' at line 1 (127.0.0.1)