select fsp.ownerid, fsp.fsl_tablecode, fsp.fspro_userid, fsp.firstname, fsp.lastname, fsp.fspro_password from tbl_fspro_members fsp where fsp.email = and ownerid = 173 and fsl_tablecode = 'msc' and fsp.fspro_password = and nullif(FSPro_Password,'') is not null and fsp.staffmember = 1 and loginenabled = 1 select fsp.ownerid, fsp.fsl_tablecode, fsp.fspro_userid, fsp.firstname, fsp.lastname, fsp.fspro_password from tbl_fspro_members fsp where fsp.email = and ( fsp.fsl_tablecode = 'bro' or fsp.fsl_tablecode = 'mfr' ) and fsp.fspro_password = and nullif(FSPro_Password,'') is not null and fsp.staffmember = 1 and loginenabled = 1 and ownerid > 0 select gs1ContactId, productCatalogContactId, portalContactId, CRMContactId, OFSContactId from tblmanufacturers where mfr_id =