select distinct mfr_id from tbl_MFR_TPF_Detail where tPartnerType = 'OPR' and forecast_status = 'C' and mfr_id > 0 and mfr_id <> 26 and mfr_id = 54