Latest revision subquery optimisation

Problem/Motivation

IN 🐛 Updating to 10.5.3 causes gateway timeouts on revisioned content Active we joined the subquery to the using a join on the entity ID but #3548313-52: Updating to 10.5.3 causes gateway timeouts on revisioned content → makes a really interesting point about correlated vs non-correlated subqueries that potentially is the problem here and the committed fix on 🐛 Updating to 10.5.3 causes gateway timeouts on revisioned content Active is not going to address.

Steps to reproduce

Proposed resolution

Revert the fix from 🐛 Updating to 10.5.3 causes gateway timeouts on revisioned content Active and do something similar to https://github.com/Islandora/islandora/pull/1089/files

Remaining tasks

User interface changes

Introduced terminology

API changes

Data model changes

Release notes snippet