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
FShbib
.
Toggle Highlighting
SQL
SELECT DISTINCT page_title, page_len, (CASE WHEN as2.pa_importance="Top" THEN "En" WHEN as2.pa_importance="High" THEN "Çok" WHEN as2.pa_importance="Mid" THEN "Orta" WHEN as2.pa_importance="Low" THEN "Az" WHEN as2.pa_importance="NA" THEN "Bilinmeyen" WHEN as2.pa_importance="Unknown" THEN "Bilinmeyen" END) as imp FROM page INNER JOIN page_assessments as1 ON as1.pa_page_id=page_id AND as1.pa_project_id IN (SELECT pap_project_id FROM page_assessments_projects WHERE pap_project_title RLIKE "(?:[A-Za-z'/]*omen[A-Za-z'/]*|Feminism)") INNER JOIN page_assessments as2 ON as2.pa_page_id=page_id AND as2.pa_project_id=327 WHERE page_namespace = 0 AND /*page_title NOT IN (SELECT DISTINCT tr.page_title FROM trwiki_p.page tr) AND*/ page_id NOT IN (SELECT DISTINCT ll_from FROM langlinks WHERE ll_lang='ar') ORDER BY FIELD(imp,"En","Çok","Orta","Az","Bilinmeyen"), 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...