gUser search

Provides searching and filtering of global users on Wikimedia wikis.





Search syntax: Add % to your search string for multicharacter wildcards, and _ for a single-character wildcard. For example, '%Joe%' finds every username containing the word 'Joe').

Beware: search is much slower if the user name starts with a wildcard!

Could not perform query:
SQL: [709] SELECT t_user.*, t_groups.gu_groups FROM ( SELECT gu_id, gu_name, DATE_FORMAT(gu_registration, '%Y-%b-%d %H:%i') AS gu_registration, gu_locked FROM centralauth_p.globaluser WHERE UPPER(CONVERT(gu_name USING utf8)) LIKE ? AND gu_locked != ? ORDER BY gu_id DESC LIMIT 50 OFFSET 0 ) AS t_user LEFT JOIN ( SELECT gug_user, GROUP_CONCAT(gug_group SEPARATOR ', ') AS gu_groups FROM centralauth_p.global_user_groups GROUP BY gug_user ) AS t_groups ON gu_id = gug_user /*d41a9a5c*/ Sent SQL: [716] SELECT t_user.*, t_groups.gu_groups FROM ( SELECT gu_id, gu_name, DATE_FORMAT(gu_registration, '%Y-%b-%d %H:%i') AS gu_registration, gu_locked FROM centralauth_p.globaluser WHERE UPPER(CONVERT(gu_name USING utf8)) LIKE '🌝' AND gu_locked != '1' ORDER BY gu_id DESC LIMIT 50 OFFSET 0 ) AS t_user LEFT JOIN ( SELECT gug_user, GROUP_CONCAT(gug_group SEPARATOR ', ') AS gu_groups FROM centralauth_p.global_user_groups GROUP BY gug_user ) AS t_groups ON gu_id = gug_user /*d41a9a5c*/ Params: 2 Key: Position #0: paramno=0 name=[0] "" is_param=1 param_type=2 Key: Position #1: paramno=1 name=[0] "" is_param=1 param_type=2
Exception: SQLSTATE[HY000]: General error: 1300 Invalid utf8mb3 character string: 'F09F8C'

Search results

Found <b>no global accounts</b> matching [username LIKE 🌝] and [NOT locked].

※You searched for an exact match; did you want partial matches? See Search syntax above.