Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Ibrahim.ID
.
قائمة الويكيبيديين حسب عدد التعديلات
Toggle Highlighting
SQL
site = wikipedia.getSite("ar") 35 query = '''SELECT user_name, user_editcount FROM user 36 WHERE user_name NOT IN 37 (SELECT user_name FROM user_groups 38 INNER JOIN user ON user_id = ug_user WHERE ug_group = 'bot') 39 AND user_name NOT IN 40 (Select pl_title from pagelinks where pl_from = 2803691) 41 ORDER BY user_editcount DESC LIMIT 500;''' 42 wikipedia.output(u'Executing query:\n%s' % query) 43 44 conn = mysqldb.connect("arwiki.labsdb", db = site.dbName(), 45 user = config.db_username, 46 passwd = config.db_password) 47 cursor = conn.cursor() 48 query = query.encode(site.encoding()) 49 cursor.execute(query) 50 results = cursor.fetchall()
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
.
Checking query status...