mysql 的查询嵌套有关问题

mysql 的查询嵌套问题。

SQL code

 select a.*, d.sell_count from borough as a left join ( select da.* from ( select count(db.id) as sell_count,db.borough_id from housesell as db where db.borough_id = a.id ) as da ) as d where a.is_checked = 1 order by id desc LIMIT 0, 10

Copy after login

SQL code

SELECT a.*, COUNT(db.id) AS sell_count FROM borough AS a LEFT JOIN housesell AS db ON( db.borough_id = a.id) WHERE a.is_checked = 1 GROUP BY a.id ORDER BY id DESC LIMIT 0, 10 
 

Copy after login