Untitled query #588

SQL

USE huwiki_p;

/* SELECT DISTINCT page_namespace, page_title FROM langlinks JOIN page ON ll_from = page_id WHERE ll_lang = 'en'; */

/*
SELECT COUNT(*)
	FROM imagelinks
    WHERE il_to = 'Featured_article_star.svg';

DESCRIBE imagelinks;


SHOW TABLES;

SHOW GRANTS;
*/

SELECT pl_title, COUNT(pl_from) AS requests
	FROM page JOIN pagelinks ON page_id = pl_from
	WHERE page_namespace = 0 AND pl_namespace = 0 AND pl_title NOT IN (SELECT page_title FROM page WHERE page_namespace = 0);
	GROUP BY pl_title
	ORDER BY requests DESC
	LIMIT 5000;
SQL

Checking query status...
