SQL query review

Indexes, N+1, lock risk, a rewritten query.

Paste SQL plus the table sketch. Get a safer query, not a lecture on normal forms.

Public marketing description for a developer asset on CodeHub. Protected bodies are not exposed here when the asset is premium or private.