Difference between revisions of "Template:World summary sophont"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
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, existing, status | |fields=name, CONCAT('{{#if: {{#pos:{{{1}}}|(|0}} |Home|Present}}') = Home, CONCAT('{{#if: {{{1|}}}|{{#sub:{{{1|}}}|-1}}|0}}')= Percent, CONCAT(name) = text, existing, status | ||
| − | |where= | + | |where=sophont_code= "{{#if: {{{1|}}}|{{#if: {{#pos:{{{1}}}|(|0}} | {{#sub:{{{1}}}|1|4}} | {{#sub:{{{1}}}|0|-1}} }}|}}" |
|format=template | |format=template | ||
|template=World summary sophont.layout | |template=World summary sophont.layout | ||
Revision as of 18:18, 28 November 2020
Unknown column 'sophont_code' in 'where clause'
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