Articles with "orphan" tag, that has 2 or more incoming link (arwiki)

SQL

USE arwiki_p;
SELECT p.page_title, COUNT(pl.page_id) as nom
				FROM categorylinks c
				LEFT JOIN page p ON p.page_id = c.cl_from
				LEFT JOIN pagelinks pl ON p.page_title = pl.pl_title AND p.page_namespace = pl.pl_namespace AND pl.pl_from_namespace = 0
				LEFT JOIN page p2 ON p2.page_id = pl.pl_from AND p2.page_is_redirect=0 AND p2.page_namespace = p.page_namespace
				WHERE c.cl_to = "جميع_المقالات_اليتيمة"
				GROUP BY p.page_title
				having COUNT(pl.page_id)>2
                ORDER BY COUNT(pl.page_id) DESC
				LIMIT 1500;

SQL

Checking query status...