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