ITWS: ns0 pages linking to Authors without a backlink

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

Italian Wikisource: find ns0 pages (excluding subpages) linking to Authors (as the author of the text), but without a backlink to them

SQL

use itwikisource_p;
select 'Autore:'||author.page_title, text.page_title
from page author
join pagelinks on author.page_title = pagelinks.pl_title
join page text on text.page_id = pagelinks.pl_from
where author.page_namespace = 102
and text.page_namespace = 0
and author.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.

SQL

Checking query status...