SQL
x
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));
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.