SQL
AخA
SELECT
img_name,
img_size/1024,
img_height,
img_width,
img_timestamp
FROM
image
JOIN page AS p ON p.page_title = img_name
JOIN categorylinks AS cl ON p.page_id = cl.cl_from
WHERE img_width > 400
AND img_height > 400
AND img_name NOT LIKE "%.svg"
AND img_name NOT LIKE "%.pdf"
AND img_name NOT LIKE "%.tif"
AND img_name NOT LIKE "%.ogv"
AND p.page_is_redirect = 0
AND p.page_namespace = 6
AND cl_to = "جميع_الملفات_غير_الحرة";
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.