select docTitle, fileExt, contentUrl, updateDate from qmd_assets union select docTitle, fileExt, contentUrl, lastUpdatedDate as updateDate from qmd_repository order by docTitle select orgid, orgtype, firstname, lastname from tbl_fspro_members with (nolock) where fspro_userid = and ownerid = and fsl_tablecode = select companyname as partnerName from tbl_opr_clientoperators with (nolock) where operatorid = and ownerid = and fsltablecode = select cdr_dstname as partnerName from tbl_cdr_distributors with (nolock) where cdr_recordid = and ownerid = and fsl_tablecode =