Page IDs of taxon authorities not linked to Wikidata - Quarry

This query is marked as a draft This query has been published by Vahurzpu.

SQL

SELECT authorpage.page_id
FROM page authorpage
JOIN categorylinks authorcat ON authorcat.cl_from = authorpage.page_id
WHERE authorpage.page_namespace = 0
AND authorcat.cl_to = "Taxon_authorities"
AND authorpage.page_id NOT IN (SELECT pp_page FROM page_props WHERE pp_propname = "wikibase_item")
AND authorpage.page_is_redirect = 0

AخA
 
SELECT authorpage.page_idFROM page authorpageJOIN categorylinks authorcat ON authorcat.cl_from = authorpage.page_idWHERE authorpage.page_namespace = 0AND authorcat.cl_to = "Taxon_authorities"AND authorpage.page_id NOT IN (SELECT pp_page FROM page_props WHERE pp_propname = "wikibase_item")AND authorpage.page_is_redirect = 0

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

Checking query status...