select distinct jos_users.id, jos_users.email as Почта, jos_users.name as Имя, jos_users.username as Логин,
  sv1.Сотовый, sv2.Рабочий, sv3.Область, jos_users.registerDate, jos_users.lastvisitDate, sv4.Тестирований
from 
	(select jos_community_fields_values.user_id, jos_community_fields_values.value as сотовый
         from jos_community_fields_values where jos_community_fields_values.field_id=6) sv1, 
	(select jos_community_fields_values.user_id, jos_community_fields_values.value as Рабочий
         from jos_community_fields_values
         where jos_community_fields_values.field_id=7) sv2, 
	(select jos_community_fields_values.user_id, jos_community_fields_values.value as Область
         from jos_community_fields_values
         where jos_community_fields_values.field_id=9) sv3, 
	(select jos_users.id, count(*) as Тестирований
         from jos_users, TestsResultsAtt
         WHERE jos_users.id=TestsResultsAtt.user_id
         group by jos_users.id) sv4,
	jos_community_fields_values,
        jos_users, TestsResultsAtt 
where jos_users.id=TestsResultsAtt.user_id
  and jos_users.id=sv1.user_id
  and jos_users.id=sv2.user_id
  and jos_users.id=sv3.user_id
  and jos_users.id=sv4.id;

    left join sv1 on jos_users.id=sv1.user_id 
    left join sv2 on jos_users.id=sv2.user_id 
    left join sv3 on jos_users.id=sv3.user_id