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)<br/><br/>Table 'highspirits_testing.primary_part' doesn't exist