pawikisource Wikidata usage stats

SQL

use pawikisource_p;
/*select * from wbc_entity_usage;*/
SELECT eu_entity_id,page_title FROM wbc_entity_usage JOIN page ON eu_page_id=page_id WHERE page_namespace=0 AND eu_aspect='S';

SELECT COUNT(DISTINCT page_title) AS 'number of pages linked to Wikidata as sitelinks' FROM wbc_entity_usage JOIN page ON eu_page_id=page_id WHERE page_namespace=0 AND eu_aspect='S';

SELECT COUNT(DISTINCT page_title) AS 'number of pages not linked to Wikidata as sitelinks'
FROM (SELECT page_title FROM page 
      WHERE page_namespace=0 AND page_is_redirect=0 AND page_title NOT IN (SELECT page_title
                                                                           FROM wbc_entity_usage JOIN page ON eu_page_id=page_id
                                                                           WHERE page_namespace=0 AND eu_aspect='S')) AS B;
ELECT page_title FROM page 
      WHERE page_namespace=0 AND page_is_redirect=0;
SQL

Checking query status...
