Last modified: 2014-01-03 16:05:13 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-154. Summary: File info from Cat:Orphan images Issue type: Task - A task that needs to be done. Priority: Trivial Status: Done Assignee: Hoo man <hoo@online.de> ------------------------------------------------------------------------------- From: Avicennasis <Avicennasis@gmail.com> Date: Sat, 10 Sep 2011 15:00:33 ------------------------------------------------------------------------------- If at all possible, I think it would be very handy to have a list/table of files in [[Category:Orphan images]] that contains/is sortable by some basic parameters (mainly size and upload date).
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Sat, 10 Sep 2011 15:11:33 ------------------------------------------------------------------------------- First of all I guess you want that on commons?! And what data do you need in detail? File name - file size - upload time or even more? I think it's possible, though it will be slow...
------------------------------------------------------------------------------- From: Avicennasis <Avicennasis@gmail.com> Date: Sat, 10 Sep 2011 15:15:26 ------------------------------------------------------------------------------- Actually, I was looking for this on EnWp. ![][1] AFAIK, there is no tracking category of orphaned images on Commons. On EnWp, the cat has ~87k images. I believe mainly the upload date and size will help users cleanup the category. Can't think of much else that would really help. [1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Sat, 10 Sep 2011 15:17:36 ------------------------------------------------------------------------------- Ah ok, so what data do you need in detail?
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Sat, 10 Sep 2011 15:58:35 ------------------------------------------------------------------------------- SQL: SELECT /* SLOW_OK */ img_name, img_timestamp, LEFT(img_timestamp, 6), img_size, img_user_text, img_minor_mime FROM categorylinks INNER JOIN page ON cl_from = page_id INNER JOIN image ON img_name = page_title WHERE cl_to = 'Orphan_images' AND page_namespace = 6 Result: http://toolserver.org/~hoo/dbq/dbq-154.txt (plain text)
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: hoo@online.de CC list: hoo@online.de, Avicennasis@gmail.com