Part 3: issues.issue_type column related scopes updated

What does this MR do and why?

Third MR as result of splitting the larger !120520 (closed)

Database review

Query plans

I have posted the query plan links in each line of the diff so it's clear where the query is coming from. The link itself already contains a formatted version of the query.

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.

Related to #410225 (closed)