Strony wikiprojektu Kraszewski 2012

SQL

# lista indeksów linkujących do Kraszewskiego
/*SELECT page_id, page_title
	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'
;*/

# lista istniejących stron z tych indeksów
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 page_title='Krzyżacy_1410' and pl_title='Józef_Ignacy_Kraszewski' AND pl_namespace=104 AND pl_from_namespace=102 AND page_content_model='proofread-index'
        ) 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
;

/*
SELECT distinct ind_id, ind_name
    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'
        ) AS ind JOIN 
        (SELECT tl_from, tl_namespace, page_title, page_id
         	FROM templatelinks JOIN page ON tl_title=page_title AND tl_namespace=page_namespace
        ) AS p ON ind_id=pl_from
    WHERE tl_namespace=100
	limit 20 offset 70;
/*select *
	from page join page_props on page_id=pp_page
	where page_namespace=100 and pp_propname='proofread_page_quality_level'
    limit 20;
    */
SQL

Checking query status...
