Untitled query #8696

SQL

USE arwiki_p;
SELECT 
	CONCAT(' - [[',p.page_title,']] - ') as "المقالة",
	COUNT(pl.pl_from)
FROM page p
INNER JOIN categorylinks c ON p.page_id = c.cl_from AND c.cl_to = "لاعبو_كرة_قدم"
INNER JOIN templatelinks t ON p.page_id = t.tl_from AND t.tl_namespace = 10 AND t.tl_title NOT IN ('يتيمة')
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)<3
ORDER BY COUNT(pl.pl_from) DESC
limit 500;
SQL

Checking query status...
