Difference between revisions of "Template:StellarDataQuery"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
tables=StellarData, TradeSummary,BasesCode,AllegianceCode | tables=StellarData, TradeSummary,BasesCode,AllegianceCode | ||
|join on=StellarData.codes__full = TradeSummary.code__full,StellarData.bases = BasesCode.code,StellarData.allegiance = AllegianceCode.code | |join on=StellarData.codes__full = TradeSummary.code__full,StellarData.bases = BasesCode.code,StellarData.allegiance = AllegianceCode.code | ||
| − | |fields=StellarData.name, sector, subsector, era, hex, world, uwp, pcode, TradeSummary.description, sophonts, details, ix, ex, cx, | + | |fields=StellarData.name, sector, subsector, era, hex, world, uwp, pcode, TradeSummary.description, StellarData.sophonts, details, ix, ex, cx, |
nobility, bases, zone, popmul, belts, giants, worlds, allegiance, stars, wtn, ru, gwp, trade, passengers, starport_build, | nobility, bases, zone, popmul, belts, giants, worlds, allegiance, stars, wtn, ru, gwp, trade, passengers, starport_build, | ||
army, port_size, SPA, CONCAT('{{#replace:{{{name|}}}|'|''}}')= worldName, | army, port_size, SPA, CONCAT('{{#replace:{{{name|}}}|'|''}}')= worldName, | ||
Revision as of 12:51, 1 August 2018
No results This is a Cargo query template. This template queries data from the StellarData table. The data for this table is entered by using the Template:StellarData.
The query on this template uses Template: StellarData.layout to format the raw data into a page layout form.
Parameters:
- Name: Full Template: World template for the name of the world
- Non-canon trade codes: Any trade codes that are not part of the canon T5SS codes
- First Survey name: Name of the world from the first survey.
- Nahuatl name : Nahuatl name of the world for the Amec Trade Protectorate.