USE plwikisource_p;

SELECT  pl_namespace as namespace, pl_title as title, COUNT( * ) as abc 

FROM pagelinks

LEFT JOIN page as pg1 ON pg1.page_namespace = pl_namespace AND pg1.page_title = pl_title

LEFT JOIN page as pg2 ON pg2.page_id = pl_from

WHERE pg1.page_namespace IS NULL AND pl_namespace = 104 AND pg2.page_namespace not IN (8, 4)

GROUP BY pl_namespace, pl_title

HAVING COUNT(*) > 0 AND COUNT(*) > SUM(pg2.page_is_redirect)

LIMIT 1000

; 

​