Untitled query #57897

SQL

/*
select page_title from categorylinks as ca
inner join page
on page.page_id = ca.cl_from
where ca.cl_to = REPLACE("مقالات مشروع ويكي سياسة"," ","_") and ca.cl_type = "page" and page.page_namespace = 1
limit 10;
*/
SELECT page_title, pa_class, pa_importance, (
				SELECT rp.page_title
				FROM page rp
				WHERE rd_from = page_id
				AND rp.page_namespace = 0
			) AS redir_title
			FROM page
			JOIN page_assessments ON page_id = pa_page_id
			LEFT OUTER JOIN redirect ON rd_title = page_title AND rd_namespace = 0
			WHERE pa_project_id = (
				SELECT pap_project_id
				FROM page_assessments_projects
				WHERE pap_project_title = "مشروع_ويكي_مصر"
			)
			AND page_namespace = 0
SQL

Checking query status...
