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 page_id, page_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 page_id, LEFT(page_title,MAX(LENGTH(page_title))) 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
;
#Stanisław Karwowski - Historya Wielkiego Księstwa Poznańskiego T2.pdf

SQL

Checking query status...