Decompose modal locations

[greenape]

Modal locations could be further decomposed, which would be beneficial from a cache perspective.

e.g. could be broken down by taking the times_visited subquery out as a separate query, potentially also by breaking that down further.