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