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