USE zhwiki_p;

SELECT DISTINCT e.cl_from FROM

(

  SELECT DISTINCT c.cl_from FROM

  (

    SELECT DISTINCT a.cl_from FROM

    (SELECT cl_from FROM categorylinks WHERE cl_to = "合理使用图像" AND cl_type = "file") a

    LEFT JOIN templatelinks as b ON a.cl_from = b.tl_from AND tl_namespace = 10 AND tl_title = "Non-free_use_rationale"

    WHERE b.tl_from IS NULL

  ) c

  LEFT JOIN templatelinks as d ON c.cl_from = d.tl_from AND tl_namespace = 10 AND tl_title = "Non-free_use_rationale_2"

  WHERE d.tl_from IS NULL

) e

LEFT JOIN templatelinks as f ON e.cl_from = f.tl_from AND tl_namespace = 10 AND tl_title = "Non-free_fair_use_in"

WHERE f.tl_from IS NULL