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