查询指定分类的商品的写法

select a.title,a.marketprice,a.productprice,a.costprice,b.name from ims_new_shop_goods as a left join

ims_new_shop_category as b on a.pcate=b.id where a.status=1 and b.uniacid=20 and a.pcate=1;