Whatlinkshere/

SQL

USE rowiki_p;
#SELECT p.page_title, COUNT(pl.pl_from) FROM page p
SELECT 
	CONCAT('[[',p.page_title,']]') as "titlu",
	COUNT(pl.pl_from),
	CONCAT('* [[Special:Whatlinkshere/{{ns:',p.page_namespace,'}}',p.page_title,']]') as "Whatlinkshere"
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 = 4 and p2.page_is_redirect=0
where p.page_namespace = 4
GROUP BY p.page_title
ORDER BY COUNT(pl.pl_from) ASC
limit 500;
SQL

Checking query status...
