trying to find backlinks not related to templates

Fork of ITWS: ns0 pages linking to Authors without a backlink by Candalua

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

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

SQL

!!Better us_e https://en.wikipedia.org/wiki/Help:Searching
USE etwiki_p;
SELECT *
FROM pagelinks
WHERE pl_title LIKE 'USA_kveekerite_organisatsioon'
INNER JOIN page ON pl_from = page_id
INNER JOIN templatelinks ON page_id = tl_from
AND NOT EXISTS tl_title LIKE 'NobelRahu'
#AND NOT EXISTS  (select 1 from pagelinks where pl_from = author.page_id and pl_namespace = 0 and pl_title = text.page_title)
#and (
#  exists (select 1 from categorylinks where cl_from = text.page_id and cl_to = concat('Testi_di_', author.page_title))
#  or exists (select 1 from categorylinks where cl_from = text.page_id and cl_to = concat('Traduzioni_di_', author.page_title))
#)
LIMIT 99;

SQL

Checking query status...