mysql的查询嵌套有关问题

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

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