Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Mr. Ibrahem
.
Toggle Highlighting
SQL
use enwiki_p; select page_title , page_namespace , ll_title , pap_project_title , pa_class , pa_importance from page , langlinks , page_assessments , page_assessments_projects where pap_project_title = "Afghanistan" and pa_project_id = pap_project_id and pa_page_id = page_id and page_id = ll_from #and page_namespace = %d and page_is_redirect = 0 and ll_lang = 'ar' #group by pa_class , pa_importance #limit 7000 and ll_title not in (select arwiki_p.page.page_title from arwiki_p.page inner join arwiki_p.categorylinks on arwiki_p.page.page_id = arwiki_p.categorylinks.cl_from where arwiki_p.categorylinks.cl_to = "مقالات_مشروع_ويكي_أفغانستان" and ll_title = arwiki_p.page.page_title)
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...