Overused non-free files (hywiki)

Fork of Overused non-free files (lvwiki) by Edgars2007

This query is marked as a draft This query has been published by ԱշոտՏՆՂ.

SQL

USE hywiki_p;
SELECT
  concat("[[:File:",REPLACE(page_title, '_', ' '),"]]"),
  COUNT(*)
FROM imagelinks
JOIN (SELECT
        page_id,
        page_title
      FROM page
      JOIN categorylinks
      ON cl_from = page_id
      WHERE cl_to IN ("Բոլոր_ոչ_ազատ_պատկերներ", "Files with no machine-readable author",
                      "Files with no machine-readable description", "Files with no machine-readable license", 
                      "Files with no machine-readable source", "Վիճելի_կարգավիճակով_ջնջման_պատկերներ")
      AND page_namespace = 6) AS pgtmp
ON pgtmp.page_title = il_to
GROUP BY il_to
HAVING COUNT(*) > 1
ORDER BY COUNT(*) desc;

SQL

Checking query status...