Hewiki pictures many

SQL

use hewiki_p;
select page_namespace as "מרחב שם", page_title as "קובץ" from categorylinks as cl1 join page as p1
on (cl_to = "ויקיפדיה_-_תמונות_שימוש_הוגן"
 or exists
 (select * from page as p2
  where p2.page_namespace = 14
  and p2.page_title = cl1.cl_to
  and exists
  (select * from categorylinks as cl2
   where cl2.cl_from = p2.page_id
   and (cl2.cl_to = "ויקיפדיה_-_תמונות_שימוש_הוגן"
        or exists
 (select * from page as p3
  where p3.page_namespace = 14
  and p3.page_title = cl2.cl_to
  and exists
  (select * from categorylinks as cl3
   where cl3.cl_from = p3.page_id
   and (cl3.cl_to = "ויקיפדיה_-_תמונות_שימוש_הוגן")))))))
and cl_from = page_id
and page_namespace = 6
and exists
(select * from imagelinks as il1
 where il_to = page_title
and exists
(select * from imagelinks as il2
 where il2.il_to = page_title
 and il1.il_from != il2.il_from));
SQL

Checking query status...
