Replicas browser and optimizer
Untitled query #18908
This query is marked as a draft
This query has been published
Files that should not be reduced any further in size.
USE enwiki_p; SELECT DISTINCT i.img_width*i.img_height as size, CONCAT("File:",i.img_name) as name FROM image i INNER JOIN page p ON p.page_title = i.img_name AND p.page_namespace = 6 INNER JOIN categorylinks c1 ON c1.cl_from = p.page_id AND c1.cl_to = 'Non-free_images_tagged_for_no_reduction' INNER JOIN templatelinks t1 ON t1.tl_from = p.page_id AND tl_title = 'Non-free_reduce'
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in