Most linked redirects in articles on plwiki

SQL

USE plwiki_p;
SELECT DISTINCT CONCAT('# [[',page_title,']]') AS page_title, CONCAT('[[',rd_title,']]') AS rd_title, COUNT(*) AS counting
FROM page
JOIN redirect
ON rd_from = page_id
JOIN pagelinks
ON page_title = pl_title
AND page_namespace = 0
AND rd_namespace = 0
AND rd_title NOT LIKE '%(%)%'
AND page_title LIKE '%(%)%'
AND pl_namespace = 0
AND pl_from_namespace = 0
GROUP BY page_title
ORDER BY counting DESC


/*USE plwiki_p;
SELECT DISTINCT CONCAT("# [[",page_title,"]]") AS page_title, COUNT(*) AS counting
FROM page 
JOIN pagelinks ON page_title = pl_title 
WHERE page_namespace = 0 AND page_is_redirect = 1
GROUP BY page_title
ORDER BY counting DESC, page_title
LIMIT 200*/
SQL

Checking query status...
