Fork of
pawikisource Wikidata usage stats
by Ankry
This query is marked as a draft
This query has been published
by Premeditated.
SQL
x
use smnwiki_p;
/*select * from wbc_entity_usage;*/
SELECT page_title,eu_entity_id FROM wbc_entity_usage JOIN page ON eu_page_id=page_id WHERE page_namespace=0 AND eu_aspect='S'
ORDER BY page_title;
SELECT DISTINCT page_title AS 'Page not connected to Wikidata'
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');
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.