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

Source: stackoverflow.com

Similar codes

0 vote199 views1 answer
SQL Server format datetime
SQL
0 vote203 views1 answer
Raven ql select count
SQL
0 vote191 views1 answer
Mysql local password denied
SQL
0 vote216 views1 answer
Faire une recherche par liste de mot clé sql
SQL
1 vote187 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
1 vote172 views2 answers
Delete auto increment mysql
SQL
0 vote208 views1 answer
Sql period overlap
SQL
3 votes207 views1 answer
Oracle user quota on tablespace
SQL
0 vote215 views2 answers
Functions with parameters SQL
SQL
2 votes171 views2 answers
Mysql get last character of string
SQL