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 #*#pa_class , pa_importance# , count(*) as counts #* from page , langlinks , page_assessments , page_assessments_projects , arwiki_p.page arp where pap_project_title = "%s" and replace(arp.page_title," ", "_") = replace(ll_title," ", "_") and arp.page_is_redirect = 0 and page_namespace = arp.page_namespace and pa_project_id = pap_project_id and pa_page_id = page_id and page_id = ll_from and page_namespace == 0 and page_is_redirect = 0 and ll_lang = 'ar' #group by pa_class , pa_importance #limit 7000
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...