Strony wikiprojektu Kraszewski 2012

SQL

#show tables;
SELECT count(page_id)
	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 count(distinct ind_id)
    FROM (SELECT page_id AS ind_id, page_title AS index_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 LEFT JOIN pagelinks ON ind_id=pl_from JOIN page ON pl_title=page_title AND pl_namespace=page_namespace
    WHERE pl_namespace=100
	limit 20;
/*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...
