SELECT userjokeid, joketypeid, rating, addct, sendct,viewct
  FROM
  (
    SELECT DISTINCT ON(originaljokeid) ujs.userjokeid, j.joketypeid,
      CASE
        WHEN MAX(ujs.uniqueviewcount) > 0
        THEN ((MAX(ujs.addtojokeboxcount)::float8 + MAX(ujs.sendtofriendcount)::float8) * 10000 / MAX(ujs.uniqueviewcount)::float8)
        ELSE 0
      END as rating
, MAX(ujs.addtojokeboxcount) as addct
, MAX(ujs.sendtofriendcount) as sendct
, MAX(ujs.uniqueviewcount) as viewct
    FROM jokebox.userjokestats ujs
    INNER JOIN jokebox.userjoke uj
      ON ujs.userjokeid = uj.userjokeid
    INNER JOIN jokebox.jokes j ON j.jokeid = uj.jokeid
    INNER JOIN jokebox.jokestats js ON uj.jokeid = js.jokeid
    WHERE js.circulationlevelid = 1
      AND uj.jokestatusid = 2
      AND js.copyrighted = false
      AND j.joketypeid = 3
    GROUP BY originaljokeid, ujs.userjokeid, j.joketypeid
    ORDER BY originaljokeid, rating DESC
  ) AS foo
  where viewct > 9
   ORDER BY rating desc
  LIMIT 96