Template:Individual infobox/marriages: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 17: | Line 17: | ||
! style="padding-right: 1em;" {{!}} Married place DDDDD | ! style="padding-right: 1em;" {{!}} Married place DDDDD | ||
{{!}} {{{TNGmarrplace}}} EEEE }} | {{!}} {{{TNGmarrplace}}} EEEE }} | ||
{{Template:Individual infobox/getchildren|TNGfamilyID}} | {{Template:Individual infobox/getchildren|TNGfamilyID}}--> | ||
{{#get_db_data:db=tng_db | |||
-->{{#get_db_data:db=tng_db | |||
|from=tng_children LEFT JOIN tng_people ON tng_children.personID=tng_people.personID | |from=tng_children LEFT JOIN tng_people ON tng_children.personID=tng_people.personID | ||
|where=tng_children.familyID='{{{TNGfamilyID}}}' | |where=tng_children.familyID='{{{TNGfamilyID}}}' | ||
|order by=tng_people.birthdate ASC | |order by=tng_people.birthdate ASC | ||
|data={{{TNGfamilyID}}}childID=tng_children.personID,{{{TNGfamilyID}}}childlastname=tng_people.lastname,{{{TNGfamilyID}}}childfirstname=tng_people.firstname,{{{TNGfamilyID}}}childbirthdate=tng_people.birthdate,{{{TNGfamilyID}}}childdeathdate=tng_people.deathdate}} | |data={{{TNGfamilyID}}}childID=tng_children.personID,{{{TNGfamilyID}}}childlastname=tng_people.lastname,{{{TNGfamilyID}}}childfirstname=tng_people.firstname,{{{TNGfamilyID}}}childbirthdate=tng_people.birthdate,{{{TNGfamilyID}}}childdeathdate=tng_people.deathdate}} | ||
{{!}}- | {{!}}- | ||
! style="padding-right: 1em;" {{!}} Children | ! style="padding-right: 1em;" {{!}} Children {{#external_value:childID}} , {{#external_value:{{{TNGfamilyID}}}childID}} | ||
{{!}}{{#display_external_table:template=Individual infobox/children|data=childID={{{TNGfamilyID}}}childID,childlastname={{{TNGfamilyID}}}childlastname,childfirstname={{{TNGfamilyID}}}childfirstname,childbirthdate={{{TNGfamilyID}}}childbirthdate,childdeathdate={{{TNGfamilyID}}}childdeathdate}}</includeonly><noinclude> | {{!}}{{#display_external_table:template=Individual infobox/children|data=childID={{{TNGfamilyID}}}childID,childlastname={{{TNGfamilyID}}}childlastname,childfirstname={{{TNGfamilyID}}}childfirstname,childbirthdate={{{TNGfamilyID}}}childbirthdate,childdeathdate={{{TNGfamilyID}}}childdeathdate}}</includeonly><noinclude> | ||
[[Category:Data retrieval templates]] | [[Category:Data retrieval templates]] | ||
{{documentation}} | {{documentation}} | ||
</noinclude> | </noinclude> | ||
Revision as of 09:07, 1 October 2014
{{#invoke:documentation|main|_content={{ {{#invoke:documentation|contentTitle}}}}}}