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