Difference between revisions of "Template: PrintTopRN"
| Line 9: | Line 9: | ||
|fields=CONCAT('[[File:',Image,'|50px|link=]]') | |fields=CONCAT('[[File:',Image,'|50px|link=]]') | ||
|delimiter= | |delimiter= | ||
| − | |where=ComponentId HOLDS "{{{ComponentId|}}}" AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" {{#switch:{{#explode:{{FULLPAGENAME}}|/|3}}|Hosted=AND DeploymentType.Name!="Private Edition"|#default=}}</td> | + | |where=ComponentId HOLDS "{{{ComponentId|}}}" AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" {{#switch:{{#explode:{{FULLPAGENAME}}|/|3}}|Hosted=AND DeploymentType.Name!="Private Edition"|#default=}} }}</td> |
<td>{{#cargo_query: | <td>{{#cargo_query: | ||
table=ComponentRN,DeploymentType | table=ComponentRN,DeploymentType | ||
Revision as of 02:04, June 29, 2021
Query: SELECT CONCAT('50px') 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" ORDER BY CONCAT('50px') 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" ORDE' at line 1 (127.0.0.1)
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)