Difference between revisions of "Template:StellarDataArticleHeader"
Jump to navigation
Jump to search
(Created page with "{{#cargo_query: tables=StellarData, TradeSummary,BasesCode,AllegianceCode |join on=StellarData.codes__full = TradeSummary.code__full,StellarData.bases = BasesCode.code,Stell...") |
|||
| Line 7: | Line 7: | ||
REPLACE(REPLACE(BasesCode.description,'%Allegiance%',COALESCE(AllegianceCode.short_name, '')),'%article%',COALESCE(AllegianceCode.article,'a')) = basesDescription, | REPLACE(REPLACE(BasesCode.description,'%Allegiance%',COALESCE(AllegianceCode.short_name, '')),'%article%',COALESCE(AllegianceCode.article,'a')) = basesDescription, | ||
CONCAT('{{#replace:{{{Non-canon trade codes|}}}|'|''}}')=NCcodes | CONCAT('{{#replace:{{{Non-canon trade codes|}}}|'|''}}')=NCcodes | ||
| − | |where StellarData.world="{{#titleparts: {{PAGENAME}}}}" {{#if:{{{era|}}}| AND era = CONCAT('{{#replace:{{{era}}}|'|''}}')}} | + | |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') | |order by=FIELD(era, 'Milieu 1116', 'Milieu 0', 'Second Survey', 'Milieu 1130', 'New Era') | ||
| − | |||
|format=template | |format=template | ||
|template=User:Tjoneslo/StellarDataArticleHeader.layout | |template=User:Tjoneslo/StellarDataArticleHeader.layout | ||
|named args=yes | |named args=yes | ||
}} | }} | ||
Revision as of 17:19, 2 November 2024
No results