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