Utenti attivi in Commons e Wikipedia in italiano

Nomi utente esistenti sia in Commons sia in Wikipedia in italiano, con un certo numero di contributi in entrambi e almeno un contributo recente in Commons

SQL

SET SESSION group_concat_max_len = 100000000;
USE itwiki_p;
SET @l = ( SELECT GROUP_CONCAT(TO_BASE64(user_name)) AS u
          FROM user
          WHERE user_editcount > 100
          ORDER BY u DESC);
USE commonswiki_p;
SELECT user_name, user_editcount, count(log_id) as uploads
FROM user
JOIN logging
ON log_user = user_id
AND log_type = 'upload'
AND log_timestamp > '20170101000000'
WHERE user_editcount > 100
AND FIND_IN_SET(TO_BASE64(user_name), @l)
GROUP BY log_user_text
HAVING uploads > 10
ORDER BY user_editcount DESC;

SQL

Checking query status...