Debug info: ERROR: missing FROM-clause entry for table "uf1d_1"

LINE 14: ... $6 ESCAPE '\' OR idnumber ILIKE $7 ESCAPE '\' OR uf1d_1.dat...

^

SELECT DISTINCT u.id

FROM mdl_user u

JOIN (SELECT DISTINCT eu1_u.id

FROM mdl_user eu1_u

JOIN mdl_user_enrolments ej1_ue ON ej1_ue.userid = eu1_u.id

JOIN mdl_enrol ej1_e ON (ej1_e.id = ej1_ue.enrolid AND ej1_e.courseid = $1)

WHERE 1 = 1 AND eu1_u.deleted = 0) je

ON je.id = u.id

JOIN mdl_role_assignments ra

ON u.id = ra.userid

WHERE ra.roleid = $2

AND u.deleted = 0

AND ( '' || COALESCE(u.firstname, $3) || ' ' || COALESCE(u.lastname, $4) ILIKE $5 ESCAPE '\' OR email ILIKE $6 ESCAPE '\' OR idnumber ILIKE $7 ESCAPE '\' OR uf1d_1.data ILIKE $8 ESCAPE '\')

AND ra.contextid IN ($9,$10,$11)

[array (

0 => '2',

1 => '5',

2 => '',

3 => '',

4 => '%h%',

5 => '%h%',

6 => '%h%',

7 => '%h%',

8 => '30',

9 => '3',

10 => '1',

)]

Error code: dmlreadexception