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}}"}}</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
{{#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)