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 LIKE "السعودية")
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.
All SQL code is licensed under CC0 License.