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