Uncategorized commons files of specific uploader...

SQL

use commonswiki_p;
  SELECT img_user_text AS Uploader, COUNT(page_title) AS Files
   FROM image, page, categorylinks, templatelinks
   WHERE page.page_id=categorylinks.cl_from 
       AND image.img_name = page.page_title and templatelinks.tl_from = page.page_id
       and templatelinks.tl_title = "Cs"
       AND categorylinks.cl_to like "Media_needing_categories%"
GROUP BY Uploader
/*
  SELECT image.img_name
   FROM image, page as p1, categorylinks, page_props, page as p2
   WHERE image.img_user_text = "XXN" 
       AND p1.page_id=categorylinks.cl_from 
       and image.img_name = p1.page_title
#       AND categorylinks.cl_to like "Media_needing_categories%"
and categorylinks.cl_to = p2.page_title
and p2.page_id = page_props.pp_page
and page_props.pp_propname = 'hiddencat'
GROUP BY image.img_name
having count(categorylinks.cl_from)-count(page_props.pp_propname) = 0;
*/
SQL

Checking query status...
