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 vote338 views1 answer
Selecting Multiple Columns in SQL
SQL
0 vote305 views1 answer
Mariadb used space
SQL
18 votes292 views4 answers
Foreign key mySql
SQL
0 vote329 views1 answer
How to delete python anywhere mysql database
SQL
19 votes337 views6 answers
Mysql if null
SQL
0 vote342 views1 answer
Modifier une valeur sql
SQL
2 votes347 views2 answers
Sqlalchemy return id after insert
SQL
1 vote315 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote372 views1 answer
Select * from mysql.proc
SQL
0 vote344 views1 answer
Add created and updatedAt fields in mysql
SQL