Untitled query #92828

SQL

SELECT 
  page_title,
  img_size,
  img_width,
  img_height,
  CONCAT('https://commons.wikimedia.org/wiki/File:', page_title) AS file_page,
  CONCAT('https://commons.wikimedia.org/wiki/Special:FilePath/', page_title) AS file_url
FROM 
  commonswiki_p.page
JOIN 
  commonswiki_p.image ON page_title = img_name
WHERE 
  page_namespace = 6 AND -- File namespace
  img_media_type = 'DRAWING' AND -- SVG files
  img_major_mime = 'image' AND
  img_minor_mime = 'svg+xml' AND
  -- img_size > 100000 AND -- At least 100KB
  img_size < 10000000 AND -- Up to 10MB
  page_is_redirect = 0
ORDER BY 
  img_size DESC
LIMIT 
  29000 -- Adjust based on avg. file size (~200GB)
SQL

Checking query status...
