: SELECT testID, test_type, test_number, vendor, tng_dna_tests.gedcom, tng_dna_tests.personID, treename, ydna_haplogroup, mtdna_haplogroup, markers, ydna_confirmed, mtdna_confirmed, person_name, private_dna, private_test, dna_group, dna_group_desc, surnames, MD_ancestorID, MRC_ancestorID FROM tng_dna_tests INNER JOIN tng_trees on tng_dna_tests.gedcom = tng_trees.gedcom WHERE tng_dna_tests.gedcom = "JamesWilson" AND tng_dna_tests.private_test != "1" ORDER BY test_type, dna_group_desc, personID, vendor, test_date LIMIT 50

Unknown column 'ydna_haplogroup' in 'field list'