' [Product_Code]=prodcode
' and
' not (deleted)