[Product_Code] = prodcode
and
not (deleted)