USE ltwiki_p;

SELECT 

    CONCAT('[[',p.page_title,']]') as "Test",

    COUNT(pl.pl_from) as "Count"

FROM page p

INNER JOIN pagelinks pl ON p.page_title = pl.pl_title AND p.page_namespace = pl.pl_namespace

INNER JOIN page p2 ON p2.page_id = pl.pl_from

AND pl.pl_from_namespace = 0 and p2.page_is_redirect=0

GROUP BY p.page_title

having COUNT(pl.pl_from)>2

ORDER BY COUNT(pl.pl_from) DESC

limit 100;