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

SQL

​x
 
USE commonswiki_p;
​
SELECT COUNT(DISTINCT gil_wiki, gil_page_namespace_id, gil_page_title)
FROM globalimagelinks
WHERE gil_wiki != 'commonswiki'
AND gil_wiki LIKE '%wiki'
AND gil_page_namespace_id = 0
AND gil_to IN (
  SELECT img_name
  FROM image
  WHERE img_media_type IN ('AUDIO', 'VIDEO')
);
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
All SQL code is licensed under CC0 License.

Checking query status...