SELECT * FROM xcart.products WHERE productcode='P301' AND forsale='Y'