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