Difference between revisions of "Template:StellarDataQuery"
Jump to navigation
Jump to search
| Line 9: | Line 9: | ||
CONCAT('{{#replace:{{{Non-canon trade codes|}}}|'|''}}')=NCcodes, | CONCAT('{{#replace:{{{Non-canon trade codes|}}}|'|''}}')=NCcodes, | ||
CONCAT('{{#replace:{{{First Survey name|}}}|'|''}}')=FSName | CONCAT('{{#replace:{{{First Survey name|}}}|'|''}}')=FSName | ||
| − | |where=StellarData.world="{{#titleparts: {{PAGENAME}}}}" | + | |where=StellarData.world="{{#titleparts: {{PAGENAME}}}}" {{#if:{{{era|}}}| AND era = CONCAT('{{#replace:{{{era}}}|'|''}}')}} |
|order by=FIELD(era, 'Milieu 1116', 'Milieu 0', 'Second Survey', 'New Era') | |order by=FIELD(era, 'Milieu 1116', 'Milieu 0', 'Second Survey', 'New Era') | ||
|format=template | |format=template | ||
Revision as of 12:01, 29 May 2017
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.