This query is marked as a draft This query has been published by ASammour.

SQL

AخA
 
use arwiki_p;
select p.page_title, count(frwiki_p.categorylinks.cl_from)
from page p
inner join langlinks l1
on l1.ll_from = p.page_id
inner join frwiki_p.page
on frwiki_p.page.page_title = replace(l1.ll_title," ", "_")
inner join frwiki_p.categorylinks
on frwiki_p.categorylinks.cl_from = frwiki_p.page.page_id
inner join frwiki_p.page p2
on p2.page_title = frwiki_p.categorylinks.cl_to
inner join frwiki_p.langlinks el
on p2.page_id  = el.ll_from
inner join page p3
on p3.page_title = replace(replace(el.ll_title, "تصنيف:",""), " ", "_")
where p.page_is_redirect = 0
and p.page_namespace =0
and frwiki_p.page.page_namespace = 0
and frwiki_p.page.page_is_redirect = 0
and p2.page_title like "Portail:%"
and p.page_id not in (select cl_from from categorylinks where cl_to = p3.page_title)
and p.page_id not in (select cl_from from categorylinks  where cl_to = 'صفحات_لا_تقبل_شريط_بوابات')
and p2.page_is_redirect = 0
and p2.page_namespace = 14
and p3.page_namespace = 14
and p3.page_is_redirect = 0
and l1.ll_lang like "fr"
and el.ll_lang like "ar"
group by p.page_title
limit 5;
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.

Checking query status...