Erland Coombs Rogers^[1]

1896 - 1988  (92 years)




: SELECT tng_dna_tests.testID, tng_dna_tests.personID as tpersonID, tng_dna_tests.gedcom as tgedcom, test_type, test_number, test_date, match_date, markers, mtdna_haplogroup, ydna_haplogroup, hvr1_results, hvr2_results, y_results, person_name, mtdna_confirmed, ydna_confirmed, notes, markeropt, notesopt, linksopt, surnamesopt, private_dna,urls, surnames, MD_ancestorID, MRC_ancestorID, admin_notes, medialinks, ref_seq, xtra_mut, coding_reg, shared_cMs, shared_segments, chromosome, segment_start, segment_end, centiMorgans, matching_SNPs, x_match, relationship_range, suggested_relationship, actual_relationship, related_side, GEDmatchID, private_test FROM tng_dna_tests, tng_dna_links WHERE tng_dna_links.personID = "P11105" AND tng_dna_links.gedcom = "JamesWilson" AND tng_dna_links.testID = tng_dna_tests.testID ORDER BY match_date DESC, test_type ASC, markers * 1 ASC, test_number * 1 ASC

Unknown column 'match_date' in 'field list'