SELECT id, row_number() OVER (ORDER BY
    ((GREATEST("weightedVotes", POWER("weightedVotes", 1.2)) + "weightedComments"/2)
    /
    POWER(GREATEST(3, EXTRACT(EPOCH FROM (now_utc() - created_at))/3600), 1.3)
    +
    (boost/5000::float)
    /
    POWER(EXTRACT(EPOCH FROM (now_utc() - created_at))/3600+2, 2.6)) DESC NULLS LAST, id DESC) as rank
FROM "Item"
WHERE "parentId" IS NULL AND NOT bio AND "pinId" IS NULL AND "deletedAt" IS NULL
AND "weightedVotes" > 0
ORDER BY
    ((GREATEST("weightedVotes", POWER("weightedVotes", 1.2)) + "weightedComments"/2)
    /
    POWER(GREATEST(3, EXTRACT(EPOCH FROM (now_utc() - created_at))/3600), 1.3)
    +
    (boost/5000::float)
    /
    POWER(EXTRACT(EPOCH FROM (now_utc() - created_at))/3600+2, 2.6)) DESC NULLS LAST, id DESC
LIMIT 2100;