select a.*,b.category, c.level, c.level_auth, c.auth_step from gd_goods a left join gd_goods_link b on a.goodsno=b.goodsno join gd_category c on b.category = c.category where b.hidden=0 and a.goodsno='9398' and a.cj_goods = 0 limit 1