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