articles_in_which_there_is_a_link_to_user_pages

SQL

SELECT	cl_to, COUNT(cl_from) as editcount

	FROM categorylinks
	WHERE cl_from IN (
		SELECT DISTINCT ll_from
		FROM langlinks
		WHERE ll_lang = "ar"
	)
	AND cl_to NOT IN (
		SELECT DISTINCT page_title
		FROM langlinks
		LEFT JOIN page ON page_id = ll_from
		WHERE ll_lang = "ar"
		AND page_namespace = 14
	)
	AND NOT 
		( cl_to LIKE "%rticle%"
		OR  cl_to LIKE "%ages%"
		OR  cl_to LIKE "%All%"
		OR  cl_to LIKE "%using%"
		OR  cl_to LIKE "%Good"
		OR  cl_to LIKE "%Wikipedia%"
		OR  cl_to LIKE "%missing%"
		OR  cl_to LIKE "%with%"
		OR  cl_to LIKE "%anguage%"
		OR  cl_to LIKE "%template%"
		OR  cl_to LIKE "%box%"
		OR  cl_to LIKE "%stub%"
		OR  cl_to LIKE "%Use%"
		OR  cl_to LIKE "%dmy%"
		OR  cl_to LIKE "%ikidata%"
		OR  cl_to LIKE "%CS1%"
		OR  cl_to LIKE "%list%"
		OR  cl_to LIKE "%image%"
		OR  cl_to LIKE "%mdy%"
		OR  cl_to LIKE "%TOC%"
		OR  cl_to LIKE "%mdy%"
		OR  cl_to LIKE "%ategory%"
		OR  cl_to LIKE "%edirect%"
		OR  cl_to LIKE "%Cite%"
		OR  cl_to LIKE "%link%"
		OR  cl_to LIKE "%need%"
		OR  cl_to LIKE "%Engvar%"
		OR  cl_to LIKE "%ommon%"
		)

GROUP BY cl_to
ORDER BY COUNT(cl_from) DESC
LIMIT 10;
SQL

Checking query status...
