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

This query is marked as a draft This query has been published by Yethrosh.

SQL

SELECT ur.user_name, ur.user_editcount, ur.user_registration, 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_value NOT IN ('male', 'female')

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...