SELECT
		C.libelle AS typeprestataire,COUNT(*) decompte
	
	FROM prestataire B 
	LEFT JOIN p_typeprestataire C ON (C.`codeTypePrestataire`=B.`codeTypePrestataire`)
	LEFT JOIN `localite` L ON (L.codeLocalite=B.codeLocalite)
	WHERE L.`codePays`!="CI"
	GROUP BY C.libelle
	ORDER BY decompte DESC

