SELECT  evergreen.lowercase(CAST(users.family_name AS text)), evergreen.lowercase(CAST(users.first_given_name AS text)), evergreen.lowercase(CAST(users.second_given_name AS text)), evergreen.lowercase(CAST(users.dob AS text)), evergreen.lowercase(CAST(users.id AS text))
FROM  actor.usr AS users
  JOIN actor.org_unit_descendants(1) d ON (d.id = users.home_ou)
  JOIN (SELECT id as id FROM actor.usr u WHERE evergreen.unaccent_and_squash(CAST(family_name AS text)) ~ '^sharp') AS search ON (search.id = users.id)
WHERE users.deleted = FALSE
 GROUP BY evergreen.lowercase(CAST(users.family_name AS text)), evergreen.lowercase(CAST(users.first_given_name AS text)), evergreen.lowercase(CAST(users.second_given_name AS text)), evergreen.lowercase(CAST(users.dob AS text)), evergreen.lowercase(CAST(users.id AS text))
 ORDER BY evergreen.lowercase(CAST(users.family_name AS text)) ASC, evergreen.lowercase(CAST(users.first_given_name AS text)) ASC, evergreen.lowercase(CAST(users.second_given_name AS text)) ASC, evergreen.lowerca^C(CAST(users.dob AS text)) DESC, evergreen.lowercase(CAST(users.id AS text))
 LIMIT 25
 OFFSET 0
;
