_secId = "5171"; // CMM Section ID for '1FS Boker Partner' (on DEV) _brokerProfileCatId = "33537"; _secId = "5171"; // CMM Section ID for '1FS Boker Partner' (on PROD) _brokerProfileCatId = "33537"; select img.image from tblBrokers b with (nolock) inner join qryImageFullPathLookup img on b.BrokerCompanyLogo = img.ImageID where broker_Id = select attrId from tbl_ORG_Attributes with (nolock) where attrDescription = select * from qmd_getBrokerPartners order by broker_Name