select ownerId, ownerType, objectiveId from tbl_BCRM_Objectives where objLevel != 'P' and ready = 'Y' and getDate() between publishDate and unpublishDate and ownerId > 0 and ownerType in ( 'MFR', 'BRO' ) order by objectiveId desc

Runtime: #getTickCount() - _startTicks# ms.