rendered paste body#
table: tng_people
#
----------------+---------------
#
gedcom | varchar(20)
#
personID | varchar(22)
#
lastname | varchar(127)
#
firstname | varchar(127)
#
----------------+---------------
#
#
table: tng_families
#
----------------+---------------+------------------
#
gedcom | varchar(20) | [SMI]
#
familyID | varchar(22) | [example: F104]
#
husband | varchar(22) | [example: I2106]
#
wife | varchar(22) | [example: I736]
#
marrdatetr | date | [0000-00-00]
#
----------------+---------------+------------------
#
#
1. List pairs of husband and wifes that share family ID AND gedcom SORTED by marrdatetr