Lo-res IWM images that are in use

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

SQL

SELECT 
  img_name,
  img_width,
  img_height
FROM 
  image
JOIN 
  imagelinks ON il_to = img_name
JOIN 
  globalimagelinks ON globalimagelinks.gil_to = img_name
JOIN 
  externallinks ON externallinks.el_from = imagelinks.il_from
WHERE 
  externallinks.el_to_domain_index LIKE '%iwm%'
AND 
  externallinks.el_to_path LIKE '%media%'
AND 
  img_width <= 800
AND 
  globalimagelinks.gil_wiki != 'commonswiki'
LIMIT 500;

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