Difference between revisions of "Equipment"
From P6 Spheres
| Line 3: | Line 3: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Equipment_Types | tables=Equipment_Types | ||
| + | |where=TopCategory HOLDS "Mundane" | ||
|fields=CONCAT('[{{fullurl:Equipment/List|Category=', Tag, '}} ', Label, ']') | |fields=CONCAT('[{{fullurl:Equipment/List|Category=', Tag, '}} ', Label, ']') | ||
|order by=TableIndex | |order by=TableIndex | ||
| Line 11: | Line 12: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Equipment_Types | tables=Equipment_Types | ||
| + | |where=TopCategory HOLDS "Mundane" | ||
|fields=Label,Tag | |fields=Label,Tag | ||
|order by=TableIndex | |order by=TableIndex | ||
Revision as of 14:14, 15 March 2020
| Main > Equipment |
Contents
Equipment Categories
Query: SELECT CONCAT('Tag, ' ', Label, '') AS `com/p6spheres/index.php?title=Equipment/List&Category=', Tag, ' ', Label, ']')` FROM `cargo__Equipment_Types` WHERE TopCategory HOLDS "Mundane" ORDER BY `TableIndex` 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 "Mundane" ORDER BY `TableIndex` LIMIT 100' at line 1 (localhost)
Equipment Tables
Query: SELECT `Label` AS `Label`,`Tag` AS `Tag` FROM `cargo__Equipment_Types` WHERE TopCategory HOLDS "Mundane" ORDER BY `TableIndex` 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 "Mundane" ORDER BY `TableIndex` LIMIT 100' at line 1 (localhost)