SELECT ProdID,skuId,sku,skuDesc, MFR_ID,MFR_NAME,MfrCompanyLogo,MfrCompanyLogoUrl, startAvailabilityDate,cool_school,foodservice_rewards,hasChildNutrition, smartSnack,wholeGrain51Percent,rBGHfree,vegetarian,vegan,glutenFree,noTransFat, sortRank,gs1_syncDate,createDate,star_awards,value_plus,brand_points_plus, USDA_Commodity,categoryId,categoryDesc,randSeq, ofsCategoryId,ofsCategoryId_gs1,ofsCategoryId_manual,mfrType, showDOTicon, skuPrimaryImg200url, skuSpecSheetURL, skuSpecSheetPortalName, skuSpecSheetSharedSecret, MASTER_UNIT_QTY, MASTER_UNIT_SIZE, MASTER_UNIT_SIZE_MEASURE, SCC14, algCarrots, algCelery, algGlutenCereals, algCocoa, algCoriander, algCorn, algEggs, algFish, algLupine, algMilk, algMolluscs, algMustard, algPeanuts, algPodFruits, algRye, algSesameSeeds, algShellfish, algShellfish_type, algSoybeans, algSulphites, algTreenuts, algTreenuts_type, algWheat, algFALCPA FROM qmd_getSearchResults ORDER BY MFR_NAME, sku, skuDesc SELECT FruitAlt_UnitPerSrv, FruitAlt_UnitMeasure, Vegetable_UnitPerSrv, Vegetable_UnitMeasure, Vegetable_Color, Meat_MeatAlt_UnitPerSrv, Meat_MeatAlt_UnitMeasure, Grain_UnitPerSrv, Grain_UnitMeasure, WholeGrain_UnitPerSrv, WholeGrain_UnitMeasure, Milk_UnitPerSrv, Milk_UnitMeasure, unitPerSrv,UnitMeasure,WeightSrvGrams,srvPerContainerText,comments AS srvSizeDesc,WeightSrvGrams,UnitDescription AS ServingsDesc, calories,Fat_Cal,Fat,SaturatedFat,TransFat,Cholesterol,Sodium,Potassium, Carbs,Fiber,Sugar,Protein,VitaminA,VitaminC,Calcium,Iron, m.MFR_ID AS mfrId FROM tbl_PRD_NutritionChild INNER JOIN tblManufacturers m ON OwnerId = m.MFR_ID WHERE NutType = 'SKU' AND linkID = AND FSL_TableCode = 'MFR' AND OwnerID =