select m.mfr_id, m.mfr_name, count( distinct s.skuId ) skuCount from tblManufacturers m inner join tbl_PRD_Skus s on s.ownerId = m.mfr_id and s.fsl_tablecode = 'MFR' inner join tbl_PRD_Packaging pkg on pkg.linkId = s.skuId and pkg.linkType = 'SKU' inner join tbl_PRD_Nutrition n on n.linkId = s.skuId and n.nuttype = 'SKU' where s.gs1_syncDate is not null and nullif ( pkg.scc14, '' ) is not null group by m.mfr_id, m.mfr_name order by m.mfr_name select m.firstName, m.lastName, m.email from tblManufacturers mfr inner join tbl_FSPRO_members m on m.fspro_userid = coalesce( nullif( fseproductCatalogContactId, 0 ), fseContactId ) where mfr.mfr_id = select count(*) batchCount from tbl_EAI_inboundBatches where ownerId = and ownertype = 'MFR' and fileFormat = '$GS1_ItemRefresh' and status in ( 'PENDING', 'RUNNING' )

Manufacturer	GS1 SKUS w/Nutrition	Status	FSE Contact
#htmleditformat( mfr_name )#	#lsnumberformat( skuCount )#	ReprocessingDifferences	#htmleditformat( qmd_fseContact.email )#

---

select p.scc14 gtin, Alcohol, Ash, Ash_Equv, Biotin,Biotin_Equv, Caffeine, Calcium,Calcium_Type,Calcium_Equv,Calcium_Type_Equv, Calories,Calories_Equv, Carbs,Carbs_Equv,Carbs_PDV,Carbs_other,Carbs_other_equv, Cholesterol,Cholesterol_Equv,Cholesterol_PDV, Choline,Choline_Type,Choline_Equv,Choline_Type_Equv, Copper,Copper_Equv, Chromium,Chromium_Equv, Energy,Energy_Equv, Fat,Fat_Equv,Fat_PDV, Fat_Cal,Fat_Cal_Equv, Fiber,Fiber_Equv,Fiber_PDV, Fiber_Soluble,Fiber_Soluble_Equv, Fiber_Insoluble,Fiber_Insoluble_Equv, Folate,Folate_Equv, Iodine,Iodine_Equv, Iron,Iron_Type,Iron_Equv,Iron_Type_Equv, Magnesium,Magnesium_Equv, Manganese,Manganese_Equv, Moisture,Moisture_Equv, Molybdenum,Molybdenum_Equv, MonounsatFat,MonounsatFat_Equv, Niacin, Niacin_Equv, PantoAcid,PantoAcid_Equv, Phosphorous,Phosphorous_Equv, Potassium,Potassium_Equv,Potassium_PDV, PolyunsatFat,PolyunsatFat_Equv, Protein,Protein_Equv, Riboflavin,Riboflavin_Type,Riboflavin_Equv,Riboflavin_Type_Equv, SaturatedFat,SaturatedFat_Equv,SaturatedFat_PDV, Selenium,Selenium_Equv, Sodium,Sodium_Equv,Sodium_PDV, Sugar,Sugar_Equv, SugarAlcohol, Thiamin,Thiamin_Equv, Transfat,Transfat_Equv, VitaminA,VitaminA_Type, VitaminA_Equv,VitaminA_Type_Equv, VitaminB6,VitaminB6_Equv, VitaminB12,VitaminB12_Equv, VitaminC,VitaminC_Type,VitaminC_Equv,VitaminC_Type_Equv, VitaminD,VitaminD_Equv, VitaminE,VitaminE_Type,VitaminE_Equv,VitaminE_Type_Equv, VitaminK,VitaminK_Equv, Zinc,Zinc_Equv from tbl_PRD_Nutrition n inner join tbl_PRD_Packaging p on p.linkId = n.linkId and p.linkType = n.NutType and p.ownerId = n.ownerId and p.fsl_tablecode = n.fsl_tablecode inner join tbl_PRD_SKus s on s.skuId = p.linkId and s.ownerId = p.ownerId and s.fsl_tablecode = p.fsl_tablecode and s.gs1_syncDate is not null where p.linkType= 'SKU' and p.ownerId = and p.fsl_tablecode = 'MFR' and p.scc14 in ( )

#lsnumberformat( qmd_diff.recordCount )# SKUs w/Nutrition differences of #lsnumberformat( qmd_nutrition_fslibrary.recordCount )# SKUs with Nutrition

Nutrition	FSLibrary	FSLibrary_RPC
GTIN: #gtin#
#_c#	#htmleditformat( _leftVal )#	#htmleditformat( _rightVal )#