## the query SELECT DISTINCT email FROM phonebook LEFT JOIN user_data USING (user_id) LEFT JOIN user_access USING (user_id) LEFT JOIN access_keys USING (key_id) LEFT JOIN mass_list USING (user_id) WHERE mass_list.user_id IS NULL AND user_data.office <> '3' AND access_keys.name <> 'LTD' OR user_access.key_id IS NULL ## the error Unknown column 'argos_intranet.access_keys.user_id' in 'on clause'