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 * FROM pagelinks LIMIT 5;

-- SELECT pl_title, COUNT(pl_from) AS requests
	/*concat('[[', replace(pl_title, '_', ' '), ']]') AS 'Cím',
    concat('[[Speciális:Mi hivatkozik erre/', replace(pl_title, '_', ' '), '|', COUNT(pl_from), ']]') AS 'Hivatkozások száma'*/
	-- FROM page JOIN pagelinks ON page_id = pl_from LEFT JOIN page x ON pl_title = x.page_title AND x.page_namespace=0
	-- WHERE pl_title NOT IN  p.page_namespace = 0 AND pl_namespace = 0 AND x.page_title IS NULL
	-- GROUP BY pl_title
	-- ORDER BY requests DESC
	-- LIMIT 5000;
SQL

Checking query status...
