Lo-res images from the US LoC in use

SQL

CREATE TEMPORARY TABLE filtered_links AS
SELECT el_from
FROM externallinks
WHERE el_to_domain_index LIKE '%loc.gov%'
  AND el_to_path LIKE '%collections%';

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 filtered_links ON filtered_links.el_from = imagelinks.il_from
WHERE img_name NOT LIKE '%cropped%'
  AND (img_width >= 1000 OR img_height >= 1000)
  AND globalimagelinks.gil_wiki != 'commonswiki'
LIMIT 5;

SQL

Checking query status...