select objectid as mfrid from tbl_import_aliases with (nolock) where ownerid = and ownertype = and objecttype = 'mfrid' and alias = select skuid from tbl_prd_skus with (nolock) where ownerid = and fsl_tablecode = and mfrid = and sku =
Product detail not available.
 select sku.ownerid, sku.fsl_tablecode, sku.sku, sku.skuid, sku.prodid, sku.mfrid, skuDesc, packSizeDesc, mfr_name, prd.shortdesc, prd.product, upc, scc14, pkg.gtin_item, master_gross_weight, master_gross_weight_unit, master_net_weight, master_unit_qty, master_unit_size, master_unit_size_measure, master_net_weight_unit, master_unit_size_desc, master_cube, master_height, master_width, master_length, pallet_tie, master_cube_unit, master_height_unit, master_width_unit, master_length_unit, pallet_high, sku.internalnotes, sku.discontinued, sku.privateLabelType, dot.stockingStatus dotStockingStatus, dot.dotCode, sku.dst_id as privateLabelDstId, sku.foodservice_rewards, sku.star_awards, sku.value_plus, sku.cool_school, sku.brand_points_plus, sku.real_rewards_cafe, pkg.shelf_life, pkg.shelf_life_ambient, pkg.shelf_life_refrig, pkg.shelf_life_frozen, mfr.gs1_gln, pkg.kosher, pkg.kosher_comments, sku.opr_id, sku.productVideoURL, pkg.catch_weight, pkg.catch_weight_range, pkg.inner_packs_in_case, sku.additionalDesc, sku.specsheetImg, sku.sellingStatement, sku.CustomFld_1, sku.CustomFld_2, sku.CustomFld_3, sku.mfrSkuId, mfr.gs1_syncEnabled, sku.gs1_syncDate, sku.hasChildNutrition, 'Y' as gs1_syncEnabled, #dateformat(now(),"mm/dd/yyyy")# as gs1_syncDate, case when sku.focusproduct = 'y' or prd.focusproduct = 'y' then 'Y' else 'N' end as focusProduct from tbl_prd_skus sku with (nolock) left outer join tblmanufacturers mfr with (nolock) on mfr.mfr_id = sku.mfrid left outer join tbl_prd_products prd with (nolock) on prd.prodid = sku.prodid left outer join tbl_prd_packaging pkg with (nolock) on pkg.linkid = sku.skuid and pkg.linktype = 'sku' left outer join tbl_DOT_StockingStatus dot with (nolock) on dot.GTIN = pkg.scc14 and not exists ( select * from fsenablers.dbo.tbl_APP_Configurations with (nolock) where applicationCode = 'PRD' and ownerid = mfr.mfr_id and ownertype = 'MFR' and parameterName = 'display_dot_codes' and parameterValue = 'false' ) where sku.skuid = and sku.ownerid = and sku.fsl_tablecode = 'mfr' where sku.ownerid = and sku.fsl_tablecode = and sku.skuid =

select skuid from tbl_bcrm_useritemfavorites with (nolock) where ownerid = and ownertype = and fspro_userid = and skuid = select cdr.cdr_dstname distributorname from tbl_cdr_distributors cdr with (nolock) where cdr.cdr_recordid = and cdr.ownerid = and cdr.fsl_tablecode = select cdr.cdr_recordid, cdr.cdr_dstname, cdr.cdr_dstcode, fsp.firstname as cmfirst, fsp.lastname as cmlast from tbl_CDR_Distributors cdr with (nolock) left outer join tbl_fspro_members fsp with (nolock) on fsp.fspro_userid = cdr.mfr_bsr_id where cdr.OwnerID = and cdr.fsl_tablecode = and cdr.cdr_dstcode =

select sku.ownerid, sku.fsl_tablecode, sku.skuid, sku.sku, sku.prodid, sku.internalnotes, sku.privateLabelType, sku.dst_id as privateLabelDstId, prd.product, pkg.shelf_life, pkg.shelf_life_ambient, pkg.shelf_life_refrig, pkg.shelf_life_frozen, sku.foodservice_rewards, sku.star_awards, sku.value_plus, sku.cool_school, sku.brand_points_plus, sku.real_rewards_cafe, pkg.kosher, pkg.kosher_comments, sku.sellingStatement, sku.opr_id, sku.gs1_syncDate, sku.productVideoURL, sku.additionalDesc, sku.CustomFld_1, sku.CustomFld_2, sku.CustomFld_3, pkg.inner_packs_in_case, sku, sku.mfrid from tbl_prd_skus sku with (nolock) left outer join tbl_prd_products prd with (nolock) on prd.prodid = sku.prodid left outer join tbl_prd_packaging pkg with (nolock) on pkg.linkid = sku.skuid and pkg.linktype = 'SKU' where sku.ownerid = and sku.fsl_tablecode = 'MFR' and sku.skuid =
select ownerid, fsl_tablecode, skuid, sku, prodid, internalnotes, privateLabelType, privateLabelDstId, product, shelf_life, shelf_life_ambient, shelf_life_refrig, shelf_life_frozen, foodservice_rewards, star_awards, value_plus, cool_school, brand_points_plus, real_rewards_cafe, kosher, kosher_comments, opr_id, gs1_syncDate, productVideoURL, additionalDesc, sellingStatement, CustomFld_1, CustomFld_2, CustomFld_3, inner_packs_in_case, mfrid from qcf_skuInfo select count(*) as videoCount from tbl_prd_videos with (nolock) where ownerid = and ownertype = 'mfr' and ( ( linktype = 'sku' and linkid = ) or ( linktype = 'prd' and linkid = ) )
select count(*) nutritionCount from tbl_PRD_Nutrition with (nolock) where ownerid = and fsl_tablecode = and (NutType = 'sku' and linkID = ) or (NutType = 'prd' and linkID = )

select count(*) packagingCount from tbl_PRD_Packaging with (nolock) where linktype = 'sku' and linkID = select count(*) memoCount from tbl_PRD_Memo with (nolock) where linktype = 'sku' and linkID =
select b.brand_id AS brandid, b.brand, img.contentPath, img.Imagethumb, img.contentID from tbl_MFR_Brands b with (nolock) inner join tbl_PRD_Skus s with (nolock) on s.skuID = and s.BrandID = b.brand_id and s.ownerid = and s.fsl_tablecode = inner join qryContentFullPathLookup img with (nolock) on img.contentID = b.logo order by b.brand SELECT c.cho_dbaname, coalesce(c.cho_logoId,755) cho_logoId, s.subFolderURL + '/' + f.mainFolder + '/' + f.subFolder + '/' + replace(f.fileName,'.','_100.') as fileURL FROM tbl_opr_clientoperators opr with (nolock) left outer join tbl_CHO_Operators c with (nolock) on c.cho_id = opr.FSL_ChoID LEFT OUTER JOIN tbl_FSC_Content f with (nolock) ON f.ContentId = c.cho_logoid LEFT OUTER JOIN tbl_FSC_SubFolders s with (nolock) on s.subFolderCode = f.subFolder where opr.operatorid = and opr.ownerid = and opr.fsltablecode = select typ.code, typ.description, mem.memodata, umt.Unit as memoSubTypeTxt from tbl_PRD_Memo mem with (nolock) inner join tbl_PRD_MemoTypes typ with (nolock) on mem.memotype = typ.code left outer join tbl_PRD_UnitMeasureTypes umt with (nolock) on umt.UnitAbbrev = mem.memoSubType and umt.Description = 'Gs1_PreparationType' where LinkID = and LinkType = 'sku' and ownerid = and fsl_tablecode = order by mem.memotype select typ.code, typ.description, mem.memodata, umt.Unit as memoSubTypeTxt from tbl_PRD_Memo mem with (nolock) inner join tbl_PRD_MemoTypes typ with (nolock) on mem.memotype = typ.code left outer join tbl_PRD_UnitMeasureTypes umt with (nolock) on umt.UnitAbbrev = mem.memoSubType and umt.Description = 'Gs1_PreparationType' where LinkID = and LinkType = 'prd' and ownerid = and fsl_tablecode = order by mem.memotype select fieldname from tbl_rec_customflds with (nolock) where ownerid = and fsl_tablecode = and label like select fieldname from tbl_rec_customflds with (nolock) where ownerid = and fsl_tablecode = and label like select count(*) as itemCount from tbl_rec_items rec with (nolock) where rec.mfr_id = and getdate() >= publishdate and getdate() <= unpublishdate and ( #qrySkuCustomFlds.fieldname# like or 1 = 2 ) and ( #qryPrdCustomFlds.fieldname# like or 1 = 2 ) and 1 = 2 select count(*) as itemCount from tbl_rec_products with (nolock) where ( linkid = and linktype = 'sku' ) or ( linkid = and linktype = 'prd' ) select csku.customerSku, cdr.cdr_dstname as companyName from tbl_cdr_distributors cdr with (nolock) left outer join tbl_PRD_CustomerSkus csku with (nolock) on csku.skuid = and csku.customerid = cdr.cdr_recordid and csku.customertype in ('dst','pdst') where cdr.cdr_recordid = and cdr.ownerid = and cdr.fsl_tablecode = 'mfr' select csku.customerSku, opr.companyname from tbl_prd_skus sku with (nolock) inner join tbl_opr_clientoperators opr with (nolock) on opr.operatorid = sku.opr_id left outer join tbl_PRD_CustomerSkus csku with (nolock) on csku.skuid = sku.skuid and csku.customerid = opr.operatorid and csku.customertype = 'cho' where sku.ownerid = and sku.fsl_tablecode = 'mfr' and sku.skuid =
select MFRPartItemStyleModelNumber, DescriptiveSizeGroup from tbl_PRD_OtherAttributes where ownerid = and ownertype = and linktype = 'sku' and linkid =