Untitled query #76401

SQL

SELECT page_id, page_title, pl_title
	FROM categorylinks JOIN page ON cl_from=page_id LEFT JOIN pagelinks ON (pl_from=page_id AND pl_namespace=0)
	WHERE (cl_to='Projekty_proofread_do_skorygowania' OR cl_to='Projekty proofread do uwierzytelnienia') AND cl_type='page'
		AND pl_namespace IS NULL
;
SELECT idx.page_id, idx.page_title, pl_title
	FROM categorylinks JOIN page AS idx ON cl_from=idx.page_id JOIN pagelinks ON (pl_from=page_id AND pl_namespace=0)
    	LEFT JOIN page AS lnk ON pl_title=lnk.page_title AND pl_namespace=lnk.page_namespace
	WHERE (cl_to='Projekty_proofread_do_skorygowania' OR cl_to='Projekty proofread do uwierzytelnienia') AND cl_type='page'
		AND lnk.page_title IS NULL
;
SELECT DISTINCT idx.page_id, idx.page_title
	FROM categorylinks JOIN page AS idx ON cl_from=idx.page_id JOIN pagelinks ON (pl_from=page_id AND pl_namespace=0)
    	LEFT JOIN page AS lnk ON pl_title=lnk.page_title AND pl_namespace=lnk.page_namespace
	WHERE (cl_to='Projekty_proofread_do_skorygowania' OR cl_to='Projekty proofread do uwierzytelnienia') AND cl_type='page'
		AND lnk.page_title IS NULL
;
SQL

Checking query status...
