select parameterValue AS mfrAppList from fsenablers..tbl_app_configurations WITH (nolock) where applicationcode = '1FSBSR' and parametername = 'appList' and ownertype = 'mfr' /*and ( parameterValue like '%docs%' or parameterValue like '%images%' )*/ and ownerid = SELECT mfr_id, mfr_name FROM tblmanufacturers WHERE mfr_id in () and _docCat neq "-1"> and _imgCat neq "-1"> slctflds="img.ownerid, img.imgId, img.imgTitle, img.imgDescription, img.FileSize, img.FileExt, path.contentPath, img.contentId, img.sortRank, img.uploadDate" imgId="#_imgIdList#"> select child_attrId from tbl_org_attributelinks where mstr_attrTypeId = 34 and mstr_attrId = and child_attrTypeId = 30 select child_attrId from tbl_org_attributelinks where mstr_attrTypeId = 34 and mstr_attrId = and child_attrTypeId = 33 SELECT DocDescription AS DOCDESCRIPTION, DocID AS DOCID, '' AS DOCPASSWORD, DocPath AS DOCPATH, DocTitle AS DOCTITLE, FileExt AS FILEEXT, FileSize AS FILESIZE, '' AS IMGEXT, '' AS IMGNAME, '' AS IMGPATH, '' AS PSWRDPROTECT, SortRank AS SORTRANK, UploadDate AS UPLOADDATE, 'REP' AS SOURCE ,mfr_name FROM qryDocuments, qryMfrs WHERE qryDocuments.ownerid = qryMfrs.mfr_id and upper(DocPath) not like '%CLEARPIXEL%' and docid in () UNION SELECT ImgDescription AS DOCDESCRIPTION, ImgID AS DOCID, '' AS DOCPASSWORD, ContentPath AS DOCPATH, ImgTitle AS DOCTITLE, FileExt AS FILEEXT, FileSize AS FILESIZE, FileExt AS IMGEXT, ImgTitle AS IMGNAME, ContentPath AS IMGPATH, '' AS PSWRDPROTECT, SortRank AS SORTRANK, UploadDate AS UPLOADDATE, 'REP' AS SOURCE ,mfr_name FROM qryImages, qryMfrs WHERE qryImages.ownerid = qryMfrs.mfr_id AND upper(contentpath) not like '%CLEARPIXEL%' and imgid in () SELECT * FROM qcf_dispDocuments ORDER BY MFR_NAME, SORTRANK, DOCTITLE select distinct DocID, DocTitle, DocDescription, FileSize, FileExt, DocPath, PswrdProtect, DocPassword, sortrank, UploadDate, publishDate, unpublishDate, ImgPath, ImgName, ImgExt, lastUpdatedDate from qcf_dispDocuments order by UploadDate desc ---> select * from qcf_dispDocuments where docid NOT IN ()