Fork of
enwiki:Pages in WikiProject Women% and WikiProject History of Science without trwiki interwikis (page_assessments table)
by Evolutionoftheuniverse
This query is marked as a draft
This query has been published
by Balyozxane.
SQL
AخA
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 = "WikiProject France")
INNER JOIN page_assessments as2 ON as2.pa_page_id=page_id AND as2.pa_project_id=327
WHERE
page_namespace = 0 AND
page_id IN (SELECT DISTINCT ll_from FROM langlinks WHERE ll_lang='ku' AND ll_title IN (SELECT page_title FROM page WHERE page_namespace = 0 AND page_id IN (SELECT ll_from FROM langlinks WHERE ll_lang='ku')))
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.
All SQL code is licensed under CC0 License.