UserGroup Collector, order by name fix - use scalar correlated subqueries to fix MySQL error

[bozana]

S. https://forum.pkp.sfu.ca/t/bug-editorialmasterhead-500-internal-server-error/97909

Older MySQL versions do not allow references to outer query tables (u) in JOIN ON clauses inside subqueries, causing a fatal Unknown column 'u.user_id' in 'on clause' error on the Editorial Masthead page.

PR:
main

• fix: use scalar correlated subqueries for name ORDER BY to fix MySQL error #12482

stable-3_5_0:

• fix: use scalar correlated subqueries for name ORDER BY to fix MySQL … #12510
• pkp/pkp-lib#12508 submodule update ojs#5452 (only submodule update)

stable-3_4_0:

• fix: use scalar correlated subqueries for name ORDER BY to fix MySQL … #12511
• pkp/pkp-lib#12508 submodule update ojs#5453 (only submodule update)
• pkp/pkp-lib#12508 submodule update omp#2289 (only submodule update)
• pkp/pkp-lib#12508 submodule update ops#1251 (only submodule update)
  The stable-3_4_0 submodules will be updated shortly within another PR.