Attempt at finding lo-res IWM images. This might work.

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
  page ON page.page_id = imagelinks.il_from
JOIN
  revision ON revision.rev_page = page.page_id
JOIN
  text ON text.old_id = revision.rev_text_id
WHERE
  text.old_text LIKE '%iwm.org.uk%'
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...