Untitled query #79269

SQL

SELECT
    img_name,
    img_size,
    img_height, 
    img_width,
    cl1.cl_to,
    cl2.cl_to
FROM
    image
JOIN page AS p ON p.page_title = img_name
JOIN categorylinks AS cl1 ON p.page_id = cl1.cl_from
JOIN categorylinks AS cl2 ON p.page_id = cl1.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 p.page_is_redirect = 0
AND p.page_namespace = 6
AND cl1.cl_to LIKE "جميع_الملفات_غير_الحرة"
AND cl2.cl_to NOT LIKE "ملفات_غير_حرة_موسومة_لعدم_تقليل_الدقة"
GROUP BY p.page_title
SQL

Checking query status...
