Difference between revisions of "Template:World summary sophont"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Sophonts | tables=Sophonts | ||
| − | |fields=name, CONCAT('{{#if: {{#pos:{{{1}}}|(|0}} |Home|Present}}') = Home, CONCAT('{{#if: {{{1|}}}|{{#sub:{{{1|}}}|-1}}|0}}')= Percent, CONCAT(name) = text, extinct | + | |fields=name, CONCAT('{{#if: {{#pos:{{{1}}}|(|0}} |Home|Present}}') = Home, CONCAT('{{#if: {{{1|}}}|{{#sub:{{{1|}}}|-1}}|0}}')= Percent, CONCAT(name) = text, extinct, status |
|where=code = "{{#if: {{{1|}}}|{{#if: {{#pos:{{{1}}}|(|0}} | {{#sub:{{{1}}}|1|4}} | {{#sub:{{{1}}}|0|-1}} }}|}}" | |where=code = "{{#if: {{{1|}}}|{{#if: {{#pos:{{{1}}}|(|0}} | {{#sub:{{{1}}}|1|4}} | {{#sub:{{{1}}}|0|-1}} }}|}}" | ||
|format=template | |format=template | ||
Revision as of 15:48, 24 April 2016
Error: No field named "extinct" found for any of the specified database tables.
A template to expand the sophonts, one at a time. Used as part of the World Summary list at the start of a world article. See also Template:World summary sophont.layout