Difference between revisions of "Template:SectorDataQuery"

From Traveller Wiki - Science-Fiction Adventure in the Far future
Jump to navigation Jump to search
Line 26: Line 26:
 
# Subsector O:  
 
# Subsector O:  
 
# Subsector P:  
 
# Subsector P:  
 +
 +
{{#cargo_query: tables=StellarData,AllegianceCode
 +
|join on=StellarData.allegiance = AllegianceCode.code
 +
|fields=code, description, detail, detail2
 +
|group by=code
 +
|where=sector=CONCAT('{{#replace:{{{sector|}}}|'|''}}') and era=CONCAT('{{#replace:{{{era|}}}|'|''}}')
 +
|named args=yes
 +
|more results text=
 +
}}
 +
|format=template
 +
|template=SectorDataQuery.allegance.query
  
 
# Alleg: ImDd: "Third Imperium, Domain of Deneb"
 
# Alleg: ImDd: "Third Imperium, Domain of Deneb"
Line 41: Line 52:
 
  |template=SectorDataQuery.layout
 
  |template=SectorDataQuery.layout
 
  |named args=yes
 
  |named args=yes
 +
|more results text=
 
}}
 
}}
 
</pre<noinclude></noinclude> ><noinclude>[[Category:Cargo Templates]][[Category:Templates]]</noinclude>
 
</pre<noinclude></noinclude> ><noinclude>[[Category:Cargo Templates]][[Category:Templates]]</noinclude>

Revision as of 19:07, 7 May 2016

# Generated by http://wiki.travellerrpg.com/
# 2026-01-02 07:57:21+00:00

# {{{sector}}}
# -1,0

# Era: {{{era}}}

# Source:    Traveller 5 Second Survey

# Subsector A: 
# Subsector B: 
# Subsector C: 
# Subsector D: 
# Subsector E: 
# Subsector F: 
# Subsector G: 
# Subsector H: 
# Subsector I: 
# Subsector J: 
# Subsector K: 
# Subsector L: 
# Subsector M: 
# Subsector N: 
# Subsector O: 
# Subsector P: 

No results
 |format=template
 |template=SectorDataQuery.allegance.query

# Alleg: ImDd: "Third Imperium, Domain of Deneb"

Hex  Name                 UWP       Remarks                                {Ix}   (Ex)    [Cx]   N    B  Z PBG W  A    Stellar        
---- -------------------- --------- -------------------------------------- ------ ------- ------ ---- -- - --- -- ---- ---------------
No results