Untitled query #79656

SQL

SELECT
    oi_archive_name,
    oi_height, 
    oi_width
FROM
    oldimage
JOIN page AS p ON p.page_title = oi_name
JOIN categorylinks AS cl ON p.page_id = cl.cl_from
WHERE oi_width > 400
AND oi_height > 400
AND oi_name NOT LIKE "%.svg"
AND oi_name NOT LIKE "%.pdf"
AND oi_name NOT LIKE "%.tif"
AND p.page_is_redirect = 0
AND p.page_namespace = 6
AND cl_to = "جميع_الملفات_غير_الحرة"
AND oi_name NOT IN (
    SELECT im.img_name
    FROM image AS im
    JOIN page ON cl.cl_from = page.page_id
    JOIN categorylinks ON page.page_id = categorylinks.cl_from
    WHERE cl_to = "ملفات_غير_حرة_موسومة_لعدم_تقليل_الدقة"
);
SQL

Checking query status...
