اردو ویکیپیڈیا کے صارفین کے دستخط

SQL

SELECT DISTINCT ur.user_name, ur.user_editcount, ur.user_registration, up_value, ca.gu_home_db
FROM (  
  SELECT gu_name, gu_home_db  
  FROM centralauth_p.globaluser
) AS ca
JOIN urwiki_p.user AS ur ON ur.user_name = ca.gu_name
JOIN urwiki_p.user_properties AS up ON up.up_user = ur.user_id
WHERE ca.gu_home_db = 'urwiki'
AND up.up_value NOT IN ('male', 'female')
AND ur.user_name NOT LIKE 'Bot%' 
    AND ur.user_name NOT LIKE 'bot%' 
    AND ur.user_name NOT LIKE '%bot' 
    AND ur.user_name NOT LIKE '%Bot' 
    AND ur.user_name NOT LIKE '%Bot%' 
    AND ur.user_name NOT LIKE '%bot%'
    AND ur.user_name NOT LIKE 'Flow%'
    AND ur.user_name NOT LIKE 'Mediawiki%'
    AND ur.user_name NOT LIKE 'MediaWiki%'
    AND ur.user_name NOT LIKE '%Delinker'
ORDER BY ur.user_editcount DESC;

SQL

Checking query status...