قائمة الويكيبيديين حسب عدد التعديلات

SQL

USE arwiki_p;
query = SELECT user_name, user_editcount FROM user 
WHERE user_name NOT IN
(SELECT user_name FROM user_groups 
INNER JOIN user ON user_id = ug_user WHERE ug_group = 'bot') 
AND user_name NOT IN 
(Select pl_title from pagelinks where pl_from = 2803691) 
ORDER BY user_editcount DESC LIMIT 500;
wikipedia.output(u'Executing query:\n%s' % query)
 
conn = mysqldb.connect("arwiki.labsdb", db = site.dbName(),
                        user = config.db_username,
                       passwd = config.db_password)
cursor = conn.cursor()
query = query.encode(site.encoding())
cursor.execute(query)
results = cursor.fetchall()

SQL

Checking query status...