select * from product where pid='1782' and `category`='battery'