this is document id 2468 PARTNERDOC|MFR|123|2468 --> this is document id 2468 from manufacturer 123 FILE|BPL|2468 --> this is document id 2468 from the BPL repository ---> select fsc.mainfolder, fsc.subfolder, fsc.filename, fp.contentpath docUrl, doc.docTitle, doc.fileExt, doc.fileSize from tbl_doc_documents doc with (nolock) inner join tbl_fsc_content fsc with (nolock) on fsc.contentid = doc.contentid inner join qryContentFullPathLookup fp with (nolock) on fp.contentid = fsc.contentid where doc.docid = and doc.ownerid = and doc.fsl_tablecode = select fsc.mainfolder, fsc.subfolder, fsc.filename, fp.contentpath docUrl, img.ImgTitle as docTitle, img.fileExt, img.fileSize from tbl_img_images img with (nolock) inner join tbl_fsc_content fsc with (nolock) on fsc.contentid = img.contentid inner join qryContentFullPathLookup fp with (nolock) on fp.contentid = fsc.contentid where img.imgid = and img.ownerid = and img.fsl_tablecode = select fsc.mainfolder, fsc.subfolder, fsc.filename, fp.contentpath docUrl, rep.docTitle, rep.fileExt, rep.fileSize from tbl_#listgetat(attributes.subjectType,2,"|")#_repository rep with (nolock) inner join tbl_fsc_content fsc with (nolock) on fsc.contentid = rep.contentid inner join qryContentFullPathLookup fp with (nolock) on fp.contentid = fsc.contentid where rep.ownerid = and rep.ownertype = and rep.fileid = select fsc.mainfolder, fsc.subfolder, fsc.filename, fp.contentpath docUrl, doc.docTitle, doc.fileExt, doc.fileSize from tbl_doc_documents doc with (nolock) inner join tbl_fsc_content fsc with (nolock) on fsc.contentid = doc.contentid inner join qryContentFullPathLookup fp with (nolock) on fp.contentid = fsc.contentid where doc.docid = and doc.ownerid = and doc.fsl_tablecode = select fsc.mainfolder, fsc.subfolder, fsc.filename, fp.contentpath docUrl, img.ImgTitle as docTitle, img.fileExt, img.fileSize from tbl_img_images img with (nolock) inner join tbl_fsc_content fsc with (nolock) on fsc.contentid = img.contentid inner join qryContentFullPathLookup fp with (nolock) on fp.contentid = fsc.contentid where img.imgid = and img.ownerid = and img.fsl_tablecode = select fsc.mainfolder, fsc.subfolder, fsc.filename, fp.contentpath docUrl, rep.docTitle, rep.fileExt, rep.fileSize from tbl_#_repository#_repository rep with (nolock) inner join tbl_fsc_content fsc with (nolock) on fsc.contentid = rep.contentid inner join qryContentFullPathLookup fp with (nolock) on fp.contentid = fsc.contentid where rep.ownerid = and rep.ownertype = and rep.fileid = select fsc.mainfolder, fsc.subfolder, fsc.filename, fp.contentpath docUrl, sku.sku + ' ' + sku.skuDesc as docTitle, replace(img.fileext,'.','') as fileExt, img.fileSize from tbl_prd_images img with (nolock) inner join tbl_fsc_content fsc with (nolock) on fsc.contentid = img.contentid inner join qryContentFullPathLookup fp with (nolock) on fp.contentid = fsc.contentid inner join tbl_prd_skus sku with (nolock) on sku.skuid = img.linkid and sku.ownerid = img.ownerid and sku.fsl_tablecode = img.ownertype where img.contentid = and img.ownerid = and img.ownertype =