select * from breed_store_goods a inner join breed_store_multicategory b on a.goodsno=b.goods_id inner join ( select node.title,node.cateno from breed_store_category AS node, breed_store_category AS parent where node.lft BETWEEN parent.lft AND parent.rgt AND parent.cateno = '283' order by node.lft ) c on b.category_id=c.cateno where 1 and goods_display=0 group by b.goods_id order by goods_buy_count desc limit 0, 20