SELECT
*
FROM
(
   SELECT
   *, ROW_NUMBER() OVER (ORDER BY LA_STRGY_FAV.FAV DESC, LA_STRGY_FAV.LAST_ACCESS DESC, LA_STRGY.STRGY_NM) AS rowID
   FROM
   (
      SELECT
      TOP 100 PERCENT LA_STRGY.STRGY_BUSY_FLG AS busyFlag,
      LA_STRGY.CREATE_USR_ID AS create_user_id,
      LA_STRGY.CREATED AS created,
      LA_STRGY.STRGY_ERROR_FLG AS errorFlag,
      LA_STRGY_FAV.FAV AS favorite,
      LA_STRGY.HIST_END_DT AS history_end_date,
      LA_STRGY.HIST_BGN_DT AS history_start_date,
      LA_STRGY.LA_STRGY_ID AS id,
      LA_STRGY_FAV.LAST_ACCESS AS lastAccessed,
      LA_STRGY.LAST_UPDATE_USR_ID AS last_update_user_id,
      LA_STRGY.LAST_UPDATE AS last_updated,
      LA_STRGY.STRGY_STATUS_MSG AS message,
      LA_STRGY.STRGY_NM AS name,
      LA_STRGY.STRGY_END_DT AS strategy_end_date,
      LA_STRGY.STRGY_BGN_DT AS strategy_start_date,
      LOWER(username) AS create_user_name
      FROM LA_STRGY LEFT OUTER
      JOIN LA_STRGY_FAV ON
      (
         LA_STRGY.LA_STRGY_ID = LA_STRGY_FAV.LA_STRGY_ID
         AND LA_STRGY_FAV.USR_ID = -1013
      )
      JOIN AB_PERSON ON LA_STRGY.CREATE_USR_ID = AB_PERSON.id
      WHERE ('1'='1')
      ORDER BY LA_STRGY_FAV.FAV DESC,
      LA_STRGY_FAV.LAST_ACCESS DESC,
      LA_STRGY.STRGY_NM
   )
   x
)
y
WHERE y.rowID BETWEEN 1
AND 75