mysql 的查询嵌套有关问题

mysql 的查询嵌套问题。

SQL code

select a.*,  d.sell_countfrom 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 dwhere a.is_checked = 1 order by id desc LIMIT 0, 10

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.idORDER BY id DESC LIMIT 0, 10