test - Quarry

Fork of Indeksy w plwikisource przepisane, ale nie opracowane w main by Ankry

This query is marked as a draft This query has been published by Ankry.

SQL

SELECT idx.page_id, LEFT(idx.page_title, 130) page_title, pl_title, lnk.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
;

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.

SQL

Checking query status...