Strony wikiprojektu Kraszewski 2012

SQL

#show tables;
SELECT * 
	FROM pagelinks JOIN page ON pl_title=page_title RIGHT JOIN
    	(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 ON ind.ind_id=pagelinks.pl_from
    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...