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