some Uploaders with CC & GFDL

SQL

/*use enwiki_p;
  SELECT img_user_text AS Uploader, COUNT(img_name) AS Files
   FROM image
   join ipblocks
on img_user_text = ipb_address   #ipb_user = user_id
GROUP BY Uploader
having Files > 5
ORDER BY Files DESC;*/
use enwiki_p;
  SELECT img_user_text AS Uploader, COUNT(img_name) AS Files
   FROM image, page, categorylinks, ipblocks 
   WHERE page.page_id=categorylinks.cl_from 
       AND image.img_user_text = ipblocks .ipb_address
       and image.img_name = page.page_title and page.page_namespace = 6
       AND (categorylinks.cl_to = "CC-zero_files" or categorylinks.cl_to like "Creative_Commons%" 
            or categorylinks.cl_to like "Cc-by%")
GROUP BY Uploader
having Files > 5
ORDER BY Files DESC;
/*"D climacus"*/
/*USE wikidatawiki_p;
SELECT *
FROM archive where ar_title like "%disambig%"
*/
SQL

Checking query status...
