-
Improvement
-
Resolution: Fixed
-
Minor
-
4.1
-
MOODLE_401_STABLE
-
MOODLE_401_STABLE
-
See following report:
Generated SQL:
SELECT
|
u.firstname AS c0_firstname,
|
u.middlename AS c0_middlename,
|
u.lastname AS c0_lastname,
|
rbalias1.data AS c1_data
|
FROM
|
{user} u
|
LEFT JOIN {user_info_data} rbalias1 ON rbalias1.userid = u.id
|
AND rbalias1.fieldid = 2
|
LEFT JOIN {user_info_data} rbalias17 ON rbalias17.userid = u.id
|
AND rbalias17.fieldid = 2
|
WHERE
|
u.id != :rbparam0
|
AND u.deleted = 0
|
AND (
|
COALESCE(rbalias17.data, :rbparam7) = :rbparam13
|
)
|
The two joins on the {user_info_data} table are identical, and ought to be normalised away
Setting as blocked by MDL-74140 so we have an easier means of debugging reports