test2 - Quarry

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

SQL

SELECT 
  COUNT(DISTINCT il_to) AS Images_used,
  SUM(IFNULL(fairuse.img_size, commons.img_size)) / 1024 / 1024 / 1024 AS GiB
FROM page
JOIN imagelinks ON il_from=page_id
LEFT JOIN image               AS fairuse ON fairuse.img_name = il_to
LEFT JOIN commonswiki_p.image AS commons ON commons.img_name = il_to
WHERE page_namespace=0 AND page_is_redirect=0
AND (fairuse.img_name IS NOT NULL OR commons.img_name IS NOT NULL);

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...