Difference between revisions of "Template:StellarDataQuery"
Jump to navigation
Jump to search
(29 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
− | tables=StellarData, TradeSummary | + | tables=StellarData, TradeSummary,BasesCode,AllegianceCode |
− | |join on=StellarData.codes__full = TradeSummary.code__full | + | |join on=StellarData.codes__full = TradeSummary.code__full,StellarData.bases = BasesCode.code,StellarData.allegiance = AllegianceCode.code |
− | |fields=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 | + | army, port_size, SPA, CONCAT('{{#replace:{{{name|}}}|'|''}}')= worldName, |
− | |where=StellarData.world="{{#titleparts: {{PAGENAME}}}}" | + | REPLACE(REPLACE(BasesCode.description,'%Allegiance%',COALESCE(AllegianceCode.short_name, '')),'%article%',COALESCE(AllegianceCode.article,'a')) = basesDescription, |
+ | BasesCode.category = basesCategory, | ||
+ | CONCAT('{{#replace:{{{Non-canon trade codes|}}}|'|''}}')=NCcodes, | ||
+ | CONCAT('{{#replace:{{{First Survey name|}}}|'|''}}')=FSName, | ||
+ | CONCAT('{{#replace:{{{Nahuatl name|}}}|'|''}}')=NSName, | ||
+ | IF(LENGTH(TradeSummary.category)>0, CONCAT('[[',TradeSummary.category,']]'),' ')=TSCategory | ||
+ | |where=StellarData.world="{{#titleparts: {{PAGENAME}}}}" {{#if:{{{era|}}}| AND era = CONCAT('{{#replace:{{{era}}}|'|''}}')}} | ||
+ | |order by=FIELD(era, 'Milieu 1116', 'Milieu 0', 'Second Survey', 'Milieu 1130', 'New Era') | ||
|format=template | |format=template | ||
|template=StellarData.layout | |template=StellarData.layout | ||
− | }}<noinclude>[[Category: Cargo | + | |named args=yes |
+ | }}<noinclude> | ||
+ | [[Category: Cargo Templates|StellarData]] | ||
+ | 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]]. | ||
+ | * era : name of the era to be selected | ||
</noinclude> | </noinclude> |
Latest revision as of 16:25, 31 October 2021
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.
- era : name of the era to be selected