SELECT count(ClaimID) as nutriClaimDataCount FROM tbl_PRD_NutritionalClaims WHERE fsl_TableCode = AND OwnerID = AND prdLevel = AND prdid = AND ( (LowCalorie != 0 and LowCalorie IS NOT NULL) OR (CalorieFree != 0 and CalorieFree IS NOT NULL) OR (CalorieFreeFood != 0 and CalorieFreeFood IS NOT NULL) OR (FatFree != 0 and FatFree IS NOT NULL) OR (FatFreeFood != 0 and FatFreeFood IS NOT NULL) OR (LowFat != 0 and LowFat IS NOT NULL) OR (LowFatFood != 0 and LowFatFood IS NOT NULL) OR (SatFatFree != 0 and SatFatFree IS NOT NULL) OR (SatFatFreeFood != 0 and SatFatFreeFood IS NOT NULL) OR (LowSatFat != 0 and LowSatFat IS NOT NULL) OR (LowSatFatFood != 0 and LowSatFatFood IS NOT NULL) OR (CholesterolFree != 0 and CholesterolFree IS NOT NULL) OR (CholesterolFreeFood != 0 and CholesterolFreeFood IS NOT NULL) OR (LowCholesterol != 0 and LowCholesterol IS NOT NULL) OR (SodiumFree != 0 and SodiumFree IS NOT NULL) OR (VeryLowSodium != 0 and VeryLowSodium IS NOT NULL) OR (LowSodium != 0 and LowSodium IS NOT NULL) OR (reducedSodium != 0 and reducedSodium IS NOT NULL) OR (noSaltAdded != 0 and noSaltAdded IS NOT NULL) OR (SugarFree != 0 and SugarFree IS NOT NULL) OR (NoSugarAdded != 0 and NoSugarAdded IS NOT NULL) OR (HighFiber != 0 and HighFiber IS NOT NULL) OR (ExcellentSourceFiber != 0 and ExcellentSourceFiber IS NOT NULL) OR (GoodSourceFiber != 0 and GoodSourceFiber IS NOT NULL) OR (LactoseFree != 0 and LactoseFree IS NOT NULL) OR (Healthy != 0 and Healthy IS NOT NULL) OR (GoodSourceProtein != 0 and GoodSourceProtein IS NOT NULL) OR (MadeWithWholeGrain != 0 and MadeWithWholeGrain IS NOT NULL) OR (noMSG != 0 and noMSG IS NOT NULL) OR (noAddedMSG != 0 and noAddedMSG IS NOT NULL) OR (noTransFat != 0 and noTransFat IS NOT NULL) OR (zeroTransFat != 0 and zeroTransFat IS NOT NULL) OR (glutenFree != 0 and glutenFree IS NOT NULL) OR (vegan != 0 and vegan IS NOT NULL) OR (vegetarian != 0 and vegetarian IS NOT NULL) OR (wholeGrain51Percent != 0 and wholeGrain51Percent IS NOT NULL) OR (smartSnack != 0 and smartSnack IS NOT NULL) OR (rBGHfree != 0 and rBGHfree IS NOT NULL) OR (antibioticFree != 0 and antibioticFree IS NOT NULL) OR (organic != 0 and organic IS NOT NULL) OR (noPartiallyHydrogenatedOils != 0 and noPartiallyHydrogenatedOils IS NOT NULL) ) SELECT count(ClaimID) as nutriClaimDataCount FROM tbl_PRD_NutritionalClaims WHERE fsl_TableCode = AND OwnerID = AND prdLevel = AND prdid = AND ( (LowCalorie != 0 and LowCalorie IS NOT NULL) OR (CalorieFree != 0 and CalorieFree IS NOT NULL) OR (CalorieFreeFood != 0 and CalorieFreeFood IS NOT NULL) OR (FatFree != 0 and FatFree IS NOT NULL) OR (FatFreeFood != 0 and FatFreeFood IS NOT NULL) OR (LowFat != 0 and LowFat IS NOT NULL) OR (LowFatFood != 0 and LowFatFood IS NOT NULL) OR (SatFatFree != 0 and SatFatFree IS NOT NULL) OR (SatFatFreeFood != 0 and SatFatFreeFood IS NOT NULL) OR (LowSatFat != 0 and LowSatFat IS NOT NULL) OR (LowSatFatFood != 0 and LowSatFatFood IS NOT NULL) OR (CholesterolFree != 0 and CholesterolFree IS NOT NULL) OR (CholesterolFreeFood != 0 and CholesterolFreeFood IS NOT NULL) OR (LowCholesterol != 0 and LowCholesterol IS NOT NULL) OR (SodiumFree != 0 and SodiumFree IS NOT NULL) OR (VeryLowSodium != 0 and VeryLowSodium IS NOT NULL) OR (LowSodium != 0 and LowSodium IS NOT NULL) OR (reducedSodium != 0 and reducedSodium IS NOT NULL) OR (noSaltAdded != 0 and noSaltAdded IS NOT NULL) OR (SugarFree != 0 and SugarFree IS NOT NULL) OR (NoSugarAdded != 0 and NoSugarAdded IS NOT NULL) OR (HighFiber != 0 and HighFiber IS NOT NULL) OR (ExcellentSourceFiber != 0 and ExcellentSourceFiber IS NOT NULL) OR (GoodSourceFiber != 0 and GoodSourceFiber IS NOT NULL) OR (LactoseFree != 0 and LactoseFree IS NOT NULL) OR (Healthy != 0 and Healthy IS NOT NULL) OR (GoodSourceProtein != 0 and GoodSourceProtein IS NOT NULL) OR (MadeWithWholeGrain != 0 and MadeWithWholeGrain IS NOT NULL) OR (noMSG != 0 and noMSG IS NOT NULL) OR (noAddedMSG != 0 and noAddedMSG IS NOT NULL) OR (noTransFat != 0 and noTransFat IS NOT NULL) OR (zeroTransFat != 0 and zeroTransFat IS NOT NULL) OR (glutenFree != 0 and glutenFree IS NOT NULL) OR (vegan != 0 and vegan IS NOT NULL) OR (vegetarian != 0 and vegetarian IS NOT NULL) OR (wholeGrain51Percent != 0 and wholeGrain51Percent IS NOT NULL) OR (smartSnack != 0 and smartSnack IS NOT NULL) OR (rBGHfree != 0 and rBGHfree IS NOT NULL) OR (antibioticFree != 0 and antibioticFree IS NOT NULL) OR (organic != 0 and organic IS NOT NULL) OR (noPartiallyHydrogenatedOils != 0 and noPartiallyHydrogenatedOils IS NOT NULL) ) SELECT count(ClaimID) as nutriClaimDataCount FROM tbl_PRD_NutritionalClaims a INNER JOIN tbl_PRD_SKUs s ON a.prdid = s.prodid AND s.skuId = WHERE a.fsl_TableCode = AND a.OwnerID = AND a.prdLevel = AND ( (a.LowCalorie != 0 and a.LowCalorie IS NOT NULL) OR (a.CalorieFree != 0 and a.CalorieFree IS NOT NULL) OR (a.CalorieFreeFood != 0 and a.CalorieFreeFood IS NOT NULL) OR (a.FatFree != 0 and a.FatFree IS NOT NULL) OR (a.FatFreeFood != 0 and a.FatFreeFood IS NOT NULL) OR (a.LowFat != 0 and a.LowFat IS NOT NULL) OR (a.LowFatFood != 0 and a.LowFatFood IS NOT NULL) OR (a.SatFatFree != 0 and a.SatFatFree IS NOT NULL) OR (a.SatFatFreeFood != 0 and a.SatFatFreeFood IS NOT NULL) OR (a.LowSatFat != 0 and a.LowSatFat IS NOT NULL) OR (a.LowSatFatFood != 0 and a.LowSatFatFood IS NOT NULL) OR (a.CholesterolFree != 0 and a.CholesterolFree IS NOT NULL) OR (a.CholesterolFreeFood != 0 and a.CholesterolFreeFood IS NOT NULL) OR (a.LowCholesterol != 0 and a.LowCholesterol IS NOT NULL) OR (a.SodiumFree != 0 and a.SodiumFree IS NOT NULL) OR (a.VeryLowSodium != 0 and a.VeryLowSodium IS NOT NULL) OR (a.LowSodium != 0 and a.LowSodium IS NOT NULL) OR (a.reducedSodium != 0 and a.reducedSodium IS NOT NULL) OR (a.noSaltAdded != 0 and a.noSaltAdded IS NOT NULL) OR (a.SugarFree != 0 and a.SugarFree IS NOT NULL) OR (a.NoSugarAdded != 0 and a.NoSugarAdded IS NOT NULL) OR (a.HighFiber != 0 and a.HighFiber IS NOT NULL) OR (a.ExcellentSourceFiber != 0 and a.ExcellentSourceFiber IS NOT NULL) OR (a.GoodSourceFiber != 0 and a.GoodSourceFiber IS NOT NULL) OR (a.LactoseFree != 0 and a.LactoseFree IS NOT NULL) OR (a.Healthy != 0 and a.Healthy IS NOT NULL) OR (a.GoodSourceProtein != 0 and a.GoodSourceProtein IS NOT NULL) OR (a.MadeWithWholeGrain != 0 and a.MadeWithWholeGrain IS NOT NULL) OR (a.noMSG != 0 and a.noMSG IS NOT NULL) OR (a.noAddedMSG != 0 and a.noAddedMSG IS NOT NULL) OR (a.noTransFat != 0 and a.noTransFat IS NOT NULL) OR (a.zeroTransFat != 0 and a.zeroTransFat IS NOT NULL) OR (a.glutenFree != 0 and a.glutenFree IS NOT NULL) OR (a.vegan != 0 and a.vegan IS NOT NULL) OR (a.vegetarian != 0 and a.vegetarian IS NOT NULL) OR (a.wholeGrain51Percent != 0 and a.wholeGrain51Percent IS NOT NULL) OR (a.smartSnack != 0 and a.smartSnack IS NOT NULL) OR (a.rBGHfree != 0 and a.rBGHfree IS NOT NULL) OR (a.antibioticFree != 0 and a.antibioticFree IS NOT NULL) OR (a.organic != 0 and a.organic IS NOT NULL) OR (a.noPartiallyHydrogenatedOils != 0 and a.noPartiallyHydrogenatedOils IS NOT NULL) )