indexes galore; add user role to subscription cache key

[mipyykko]

Adjust a few queries as well. Now the duplicate completion removal removes from all courses and skips an extra loop.