select mfr_name from tblmanufacturers with (nolock) where mfr_id = select mfr_id from tblManufacturers mfr with (nolock) where exists ( select * from tbl_ofs_brokerskus with (nolock) where ownerid = mfr.mfr_id and ownertype = 'mfr' ) select m.mfr_name, m.mfr_id, img.imageIcon from tblManufacturers m with (nolock) inner join qryImageFullPathLookup img with (nolock) on img.imageId = m.mfrCompanyLogo inner join tbl_BRO_Principals p with (nolock) on p.mfrid = m.mfr_id and p.ownerid = and p.ownertype = where m.mfr_id in () order by p.priority, p.sortrank, m.mfr_name order by m.mfr_name

#_initialLabel#

fse:selectedmfrid="#_initialValue#" />