Untitled query #60248

SQL

use enwiki_p;
select DISTINCT concat("[[",p1.page_title,"]]"), p2.page_id, p1.page_id
FROM page p1
JOIN page p2
ON p1.page_title = p2.page_title
JOIN categorylinks
ON cl_from = p1.page_id
JOIN langlinks
WHERE cl_to = "WikiProject_Football_articles"
AND p1.page_namespace = 1
and p1.page_is_redirect = 0
AND p2.page_namespace = 0
and p2.page_is_redirect = 0
and p2.page_id Not IN (
	SELECT DISTINCT page_title
	FROM langlinks
	LEFT JOIN page ON page_id = p2.page_id
	WHERE ll_lang = "ar"
	AND page_namespace = 0) 
LIMIT 20;
SQL

Checking query status...
