SELECT
  YEAR(SWA.DATE_UPD) YR,
  WEEK(SWA.DATE_UPD) WK,
  R.RESOURCE_ID,
  R.TITLE,
  count(SWA.RESOURCE_ID) COUNT_RESOURCES
 FROM
  saved_work_analysis SWA,
  prg_live_1.RESOURCES R
 WHERE
  field_id='TRACKING_OPENRESOURCE'
  AND
  SWA.resource_id=R.resource_id
 GROUP BY
  YR,WK,SWA.RESOURCE_ID
 HAVING
  COUNT_RESOURCES >= (
                SELECT
                    count(*)
                FROM
                    saved_work_analysis SWAC
                WHERE
                    WEEK(SWAC.DATE_UPD)=WK
                    AND
                    YEAR(SWAC.DATE_UPD)=YR
                GROUP BY
                    resource_id
                ORDER BY
                    count(*) DESC
                LIMIT 19,1
                )
 ORDER BY
  YR,
  WK,
  COUNT_RESOURCES DESC

;