ORFU files, not tagged F5, w/redir counts

File pages in [[Category:All non-free media]], not in [[Category:All orphaned non-free use Wikipedia files]], and not displayed on any mainspace pages.

Seems to be a lot of them - there's only 644 pages currently in the latter cat, so there's more of these untagged than tagged.  What was that bot that tagged these again?  Has it stopped?
---
It's [[User:B-bot]].  It hasn't stopped, but it's pulling its list from [[WP:Database reports/Unused non-free files]].  And that page doesn't list files that are either
1) in use *anywhere*, not just in the main namespace, or
2) have any redirects from the file namespace, whether or not any of those are in use.

In practice, 1 isn't an issue - another bot (again, I don't remember which) removes unfree images from pages not in mainspace.  2's a big problem, though.

This query is not a suitable drop-in replacement for the one HaleBot uses; it has potential false positives for files that have two or more file redirects, the file itself is not in direct use, and at least one but not all of those redirects are in use.  (Currently, there are no such files.)  And that's also assuming that there can be a row in imagelinks for a file redirect without the file it's pointing to also having one, which doesn't seem to happen at least in practice.  In any case, see query 80422 for a version that eliminates this possibility.

Backlink: [[User talk:Legoktm#Wikipedia:Database reports/Unused non-free files]] circa [[Special:Permalink/1209291598]] on 21 February 2024.

SQL

SELECT CONCAT('File:', page_title)
FROM categorylinks
JOIN page ON page_id = cl_from
LEFT JOIN imagelinks ON il_to = page_title AND il_from_namespace = 0
WHERE page_namespace = 6
  AND cl_to = 'All_non-free_media'
  AND il_from IS NULL;

AخA
 
SELECT CONCAT('File:', page_title)FROM categorylinksJOIN page ON page_id = cl_fromLEFT JOIN imagelinks ON il_to = page_title AND il_from_namespace = 0WHERE page_namespace = 6  AND cl_to = 'All_non-free_media'  AND il_from IS NULL;

SQL

Checking query status...