mysql two joins
SELECT areas.name AS aname, COUNT(consultants.active) AS cct FROM areas LEFT JOIN consAreas ON consAreas.area = areas.id LEFT JOIN consultants ON consultants.id = consAreas.cons WHERE areas.areaID = $area AND consultants.active = 1 GROUP BY areas.name ORDER BY areas.name