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