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