SELECT *, ( SELECT contact_firstname FROM contact creator WHERE contact.contact_created_by = creator.contact_id ) AS created_by_firstname, ( SELECT contact_lastname FROM contact creator WHERE contact.contact_created_by = creator.contact_id ) AS created_by_lastname, ( SELECT contact_firstname FROM contact modifier WHERE contact.contact_last_modified_by = modifier.contact_id ) AS last_modified_by_firstname, ( SELECT contact_lastname FROM contact modifier WHERE contact.contact_last_modified_by = modifier.contact_id ) AS last_modified_by_lastname FROM contact JOIN contact_term_xref USING (contact_id) JOIN access_level USING (access_level_id) JOIN data_source USING (data_source_id) JOIN how_heard USING (how_heard_id) JOIN primary_part USING (primary_part_id) JOIN term_status USING (term_status_id) JOIN subsidy_level USING (subsidy_level_id) JOIN payment_method USING (payment_method_id) WHERE term_id IN (16)

Table 'highspirits_testing.primary_part' doesn't exist