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

2 votes183 views1 answer
Sql string_agg
SQL
0 vote198 views1 answer
Mariadb change column type
SQL
24 votes193 views5 answers
List mysql users
SQL
0 vote176 views1 answer
Left join in codeigniter query builder
SQL
0 vote173 views1 answer
Cara menampilkan user di mysql terminal
SQL
6 votes172 views1 answer
Postgresql add enum value
SQL
0 vote182 views1 answer
Sql make sure every user is unqiuew
SQL
0 vote165 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
0 vote190 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
0 vote167 views2 answers
Sql select inside select
SQL