Updated xtools query for wikidata

This query is marked as a draft This query has been published by DannyS712.

SQL

USE enwikinews_p;
SELECT ctl1.cl_to, COUNT(*), page.page_id FROM categorylinks ctl1
JOIN page ON page.page_title = ctl1.cl_to
WHERE page.page_namespace = 14
AND ctl1.cl_type = 'file'
AND ctl1.cl_from IN (
  SELECT cl_from
  FROM categorylinks ctl2
  WHERE ctl2.cl_to = 'Non-free_media'
  AND ctl2.cl_type = 'file'
)
AND page.page_id NOT IN (
  SELECT pp_page
  FROM page_props
  WHERE pp_propname = 'nogallery'
)
GROUP BY cl_to

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...