USE plwikisource_p;

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

FROM pagelinks

LEFT JOIN page as pg1

pg1.page_namespace = pl_namespace and pg1.page_title = pl_title;

LEFT JOIN page as pg2

pg2.page_id = pl_from;

WHERE pg1.page_namespace IS NULL AND pl_namespace NOT IN ( 2, 3 ) and pg2.page_namespace != 8

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

GROUP BY pl_namespace, pl_title; 

​