mysql or between two joins code example
Example: 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