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