select distinct pt_services.service_bezeichnungen, pt_class_services.class_services_name, count(*) as total
from service 
inner join pt_services  
on service.id_pt_service = pt_services.id_pt_service
inner join pt_class_services
on service.id_class_services = pt_class_services.id_class_services
group by pt_services.id_pt_service, pt_class_services.id_class_services;

select count distinct

SQL