SQL
x
SELECT distinct p1.page_title, cl1.cl_to, cl3.cl_to
from page p1
inner join categorylinks cl1
on p1.page_id = cl_from
inner join page p2
on p2.page_title = cl1.cl_to
left join categorylinks cl3
on cl3.cl_from = p2.page_id
where p1.page_namespace = 0
and p1.page_is_redirect = 0
and p2.page_namespace = 14
and p2.page_is_redirect = 0
and p2.page_id not in (select cl_from from categorylinks where cl_to = "صفحات_توضيح")
and p2.page_id not in (select cl_from from categorylinks where cl_to = "تصنيفات_مخفية")
and cl1.cl_to not like "صفحات_توضيح"
having cl3.to not in group_concat(cl1.cl_to)
limit 100;
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.