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