Untitled query #6311

SQL

use commonswiki_p;

select count(*) as uploaders, sum(c) as pictures, avg(c) as average, stddev_pop(c) as standard_deviation from  (
SELECT
 user_name,
 c,
 use_in_wiki,
 user_registration
 FROM (SELECT
   img_user,
   COUNT(*) c,
   SUM(img_name IN (SELECT DISTINCT gil_to FROM globalimagelinks)) use_in_wiki
   FROM categorylinks INNER JOIN page ON cl_from = page_id INNER JOIN image ON page_title = img_name
   WHERE cl_to = 'Images_from_Wiki_Loves_Africa_2015_in_Tunisia' AND cl_type = 'file'
   GROUP BY img_user
   ORDER BY c DESC
  ) img INNER JOIN user ON img_user = user_id
  ) d
 ;
SQL

Checking query status...
