Strony wikiprojektu Kraszewski 2012

SQL

# lista istniejących stron z indeksów Kraszewskiego
SELECT /* distinct ind_id, ind_name*/ page_title, page_id
    FROM (SELECT page_id AS ind_id, page_title AS ind_name
         	FROM pagelinks JOIN page ON pl_from=page_id
         	WHERE pl_title='Józef_Ignacy_Kraszewski' AND pl_namespace=104 
          		AND pl_from_namespace=102 AND page_content_model='proofread-index'
          		AND page_id NOT IN (199070,323326,693304,693305,693309,694580,694582,694583,694584,694585,694586,694590,694593,694594)
        ) AS ind JOIN 
		(SELECT pl_from, page_namespace, page_title, page_id
         	FROM pagelinks JOIN page ON pl_title=page_title AND pl_namespace=page_namespace
 			WHERE page_namespace=100
 		UNION SELECT tl_from AS pl_from, page_namespace, page_title, page_id
         	FROM templatelinks JOIN linktarget ON tl_target_id=lt_id JOIN page ON lt_title=page_title AND lt_namespace=page_namespace
 			WHERE page_namespace=100
    	) AS p ON ind_id=pl_from
;
SQL

Checking query status...
