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

-1 vote323 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
0 vote370 views1 answer
Prisma transaction
SQL
0 vote346 views1 answer
Get schema of table sql
SQL
16 votes339 views3 answers
Jwt secret key generator laravel
SQL
0 vote336 views1 answer
How to open mysql in docker
SQL
0 vote358 views2 answers
Script all indexes in a database
SQL
0 vote374 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote355 views1 answer
Oracle 11g forget password
SQL
11 votes371 views5 answers
Laravel db facade
SQL
4 votes319 views1 answer
To date oracle with time
SQL