Strony wikiprojektu Kraszewski 2012

SQL

#show tables;
SELECT COUNT(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'
;

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 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 * from templatelinks where tl_from = 327141 /*tl_target_id!=1*/ limit 300;
/*
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...
