DELETE FROM `xxxxx`.`ONLINEINFOAUX`
WHERE ((`COMMON_ITEM_NUMBER` = @Original_COMMON_ITEM_NUMBER) AND (`IRIS_ITEM_NUMBER` = @Original_IRIS_ITEM_NUMBER) AND ((@IsNull_UPC = 1 AND `UPC` IS NULL) OR (`UPC` = @Original_UPC)) AND ((@IsNull_ONLINE_MARKDOWN_DESCRIPTION_NOAUTOUPDATE = 1 AND `ONLINE_MARKDOWN_DESCRIPTION_NOAUTOUPDATE` IS NULL) OR (`ONLINE_MARKDOWN_DESCRIPTION_NOAUTOUPDATE` = @Original_ONLINE_MARKDOWN_DESCRIPTION_NOAUTOUPDATE)) AND ((@IsNull_CALC_SIZE = 1 AND `CALC_SIZE` IS NULL) OR (`CALC_SIZE` = @Original_CALC_SIZE)) AND ((@IsNull_MIN_SIZE = 1 AND `MIN_SIZE` IS NULL) OR (`MIN_SIZE` = @Original_MIN_SIZE)) AND ((@IsNull_MAX_SIZE = 1 AND `MAX_SIZE` IS NULL) OR (`MAX_SIZE` = @Original_MAX_SIZE)) AND ((@IsNull_SIZE = 1 AND `SIZE` IS NULL) OR (`SIZE` = @Original_SIZE)) AND ((@IsNull_UOM = 1 AND `UOM` IS NULL) OR (`UOM` = @Original_UOM)) AND ((@IsNull_CHAINWIDEITEMOFF = 1 AND `CHAINWIDEITEMOFF` IS NULL) OR (`CHAINWIDEITEMOFF` = @Original_CHAINWIDEITEMOFF)) AND ((@IsNull_PACKAGE = 1 AND `PACKAGE` IS NULL) OR (`PACKAGE` = @Original_PACKAGE)) AND ((@IsNull_PACK_INFO = 1 AND `PACK_INFO` IS NULL) OR (`PACK_INFO` = @Original_PACK_INFO)) AND ((@IsNull_SERVINGSPERCONTAINER_VALUES = 1 AND `SERVINGSPERCONTAINER_VALUES` IS NULL) OR (`SERVINGSPERCONTAINER_VALUES` = @Original_SERVINGSPERCONTAINER_VALUES)) AND ((@IsNull_SERVINGSIZE_VALUES = 1 AND `SERVINGSIZE_VALUES` IS NULL) OR (`SERVINGSIZE_VALUES` = @Original_SERVINGSIZE_VALUES)) AND ((@IsNull_CALORIES_VALUES = 1 AND `CALORIES_VALUES` IS NULL) OR (`CALORIES_VALUES` = @Original_CALORIES_VALUES)) AND ((@IsNull_TOTALFAT_VALUES = 1 AND `TOTALFAT_VALUES` IS NULL) OR (`TOTALFAT_VALUES` = @Original_TOTALFAT_VALUES)) AND ((@IsNull_SATURATEDFAT_VALUES = 1 AND `SATURATEDFAT_VALUES` IS NULL) OR (`SATURATEDFAT_VALUES` = @Original_SATURATEDFAT_VALUES)) AND ((@IsNull_TRANSFAT_VALUES = 1 AND `TRANSFAT_VALUES` IS NULL) OR (`TRANSFAT_VALUES` = @Original_TRANSFAT_VALUES)) AND ((@IsNull_CHOLESTEROL_VALUES = 1 AND `CHOLESTEROL_VALUES` IS NULL) OR (`CHOLESTEROL_VALUES` = @Original_CHOLESTEROL_VALUES)) AND ((@IsNull_SODIUM_VALUES = 1 AND `SODIUM_VALUES` IS NULL) OR (`SODIUM_VALUES` = @Original_SODIUM_VALUES)) AND ((@IsNull_TOTALCARBOHYDRATE_VALUES = 1 AND `TOTALCARBOHYDRATE_VALUES` IS NULL) OR (`TOTALCARBOHYDRATE_VALUES` = @Original_TOTALCARBOHYDRATE_VALUES)) AND ((@IsNull_DIETARYFIBER_VALUES = 1 AND `DIETARYFIBER_VALUES` IS NULL) OR (`DIETARYFIBER_VALUES` = @Original_DIETARYFIBER_VALUES)) AND ((@IsNull_TOTALSUGARS_VALUES = 1 AND `TOTALSUGARS_VALUES` IS NULL) OR (`TOTALSUGARS_VALUES` = @Original_TOTALSUGARS_VALUES)) AND ((@IsNull_ADDEDSUGARS_VALUES = 1 AND `ADDEDSUGARS_VALUES` IS NULL) OR (`ADDEDSUGARS_VALUES` = @Original_ADDEDSUGARS_VALUES)) AND ((@IsNull_PROTEIN_VALUES = 1 AND `PROTEIN_VALUES` IS NULL) OR (`PROTEIN_VALUES` = @Original_PROTEIN_VALUES)) AND ((@IsNull_VITAMIND_VALUES = 1 AND `VITAMIND_VALUES` IS NULL) OR (`VITAMIND_VALUES` = @Original_VITAMIND_VALUES)) AND ((@IsNull_CALCIUM_VALUES = 1 AND `CALCIUM_VALUES` IS NULL) OR (`CALCIUM_VALUES` = @Original_CALCIUM_VALUES)) AND ((@IsNull_POTASSIUM_VALUES = 1 AND `POTASSIUM_VALUES` IS NULL) OR (`POTASSIUM_VALUES` = @Original_POTASSIUM_VALUES)) AND ((@IsNull_IRON_VALUES = 1 AND `IRON_VALUES` IS NULL) OR (`IRON_VALUES` = @Original_IRON_VALUES)) AND ((@IsNull_ADDEDSUGARS_PERCENT = 1 AND `ADDEDSUGARS_PERCENT` IS NULL) OR (`ADDEDSUGARS_PERCENT` = @Original_ADDEDSUGARS_PERCENT)) AND ((@IsNull_SERVINGSIZE_PERCENT = 1 AND `SERVINGSIZE_PERCENT` IS NULL) OR (`SERVINGSIZE_PERCENT` = @Original_SERVINGSIZE_PERCENT)) AND ((@IsNull_CALORIES_PERCENT = 1 AND `CALORIES_PERCENT` IS NULL) OR (`CALORIES_PERCENT` = @Original_CALORIES_PERCENT)) AND ((@IsNull_TOTALFAT_PERCENT = 1 AND `TOTALFAT_PERCENT` IS NULL) OR (`TOTALFAT_PERCENT` = @Original_TOTALFAT_PERCENT)) AND ((@IsNull_SATURATEDFAT_PERCENT = 1 AND `SATURATEDFAT_PERCENT` IS NULL) OR (`SATURATEDFAT_PERCENT` = @Original_SATURATEDFAT_PERCENT)) AND ((@IsNull_CHOLESTEROL_PERCENT = 1 AND `CHOLESTEROL_PERCENT` IS NULL) OR (`CHOLESTEROL_PERCENT` = @Original_CHOLESTEROL_PERCENT)) AND ((@IsNull_SODIUM_PERCENT = 1 AND `SODIUM_PERCENT` IS NULL) OR (`SODIUM_PERCENT` = @Original_SODIUM_PERCENT)) AND ((@IsNull_TOTALCARBOHYDRATE_PERCENT = 1 AND `TOTALCARBOHYDRATE_PERCENT` IS NULL) OR (`TOTALCARBOHYDRATE_PERCENT` = @Original_TOTALCARBOHYDRATE_PERCENT)) AND ((@IsNull_DIETARYFIBER_PERCENT = 1 AND `DIETARYFIBER_PERCENT` IS NULL) OR (`DIETARYFIBER_PERCENT` = @Original_DIETARYFIBER_PERCENT)) AND ((@IsNull_VITAMIND_PERCENT = 1 AND `VITAMIND_PERCENT` IS NULL) OR (`VITAMIND_PERCENT` = @Original_VITAMIND_PERCENT)) AND ((@IsNull_CALCIUM_PERCENT = 1 AND `CALCIUM_PERCENT` IS NULL) OR (`CALCIUM_PERCENT` = @Original_CALCIUM_PERCENT)) AND ((@IsNull_POTASSIUM_PERCENT = 1 AND `POTASSIUM_PERCENT` IS NULL) OR (`POTASSIUM_PERCENT` = @Original_POTASSIUM_PERCENT)) AND ((@IsNull_IRON_PERCENT = 1 AND `IRON_PERCENT` IS NULL) OR (`IRON_PERCENT` = @Original_IRON_PERCENT)) AND ((@IsNull_IMAGES_SOURCE = 1 AND `IMAGES_SOURCE` IS NULL) OR (`IMAGES_SOURCE` = @Original_IMAGES_SOURCE)) AND ((@IsNull_MARKETINGCUTOFF = 1 AND `MARKETINGCUTOFF` IS NULL) OR (`MARKETINGCUTOFF` = @Original_MARKETINGCUTOFF)) AND ((@IsNull_OVERRIDE_KWIKEE = 1 AND `OVERRIDE_KWIKEE` IS NULL) OR (`OVERRIDE_KWIKEE` = @Original_OVERRIDE_KWIKEE)) AND ((@IsNull_FULFILLMENT_SORTING_ID = 1 AND `FULFILLMENT_SORTING_ID` IS NULL) OR (`FULFILLMENT_SORTING_ID` = @Original_FULFILLMENT_SORTING_ID)))