Fork of
Overused non-free files (lvwiki)
by Edgars2007
This query is marked as a draft
This query has been published
by ԱշոտՏՆՂ.
SQL
AخA
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.