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