select distinct ownerid from fsenablers..tbl_app_configurations where applicationcode = '1FSBSR' and parametername = 'appList' and ownertype = 'mfr' and ( parameterValue like '%docs%' or parameterValue like '%images%' ) select mfr_id, mfr_name from tblmanufacturers where mfr_id in () 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 'DOC' as type, 'joetest' as mfr_Name, DocID, DocTitle, DocDescription, FileSize, FileExt, DocPath, 0 as ContentId from qryDocuments, qryMfrs where qryDocuments.ownerid = qryMfrs.mfr_id and upper(DocPath) not like '%CLEARPIXEL%' and docid in () union select 'IMG' as type, mfr_Name, ImgID as DocID, ImgTitle as DocTitle, ImgDescription as DocDescription, FileSize, FileExt, ContentPath as DocPath, ContentID from qryImages, qryMfrs where qryImages.ownerid = qryMfrs.mfr_id and upper(contentpath) not like '%CLEARPIXEL%' and imgid in () order by mfr_Name, doctitle
#_lowerPagerDisplay#