Last modified: 2014-01-03 15:33:00 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-18. Summary: Placeholder image usage on enwiki Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: SQL <sxwiki@gmail.com> ------------------------------------------------------------------------------- From: Ilmari Karonen <nospam@vyznev.net> Date: Thu, 10 Apr 2008 23:31:25 ------------------------------------------------------------------------------- Could someone please run the following query against the enwiki database (and, optionally, report the results directly at <http://en.wikipedia.org/wiki/Image_talk:Replace_this_image_female.svg>)? SELECT il_to, COUNT![][1] FROM imagelinks, page WHERE il_to LIKE 'Replace_this_image%.svg' AND page_id = il_from AND page_namespace = 0 GROUP BY il_to This should be a very quick query – there are only a few images matching the pattern and the imagelinks table should have an appropriate index. I'd just obtain this information from the image description pages, but it seems two of those images are used on more than 500 pages, so the list shown is not complete. [1]: https://jira.toolserver.org/images/icons/emoticons/star_yellow.gif
------------------------------------------------------------------------------- From: SQL <sxwiki@gmail.com> Date: Sat, 12 Apr 2008 08:28:37 ------------------------------------------------------------------------------- I am running the query, please stand by.
------------------------------------------------------------------------------- From: SQL <sxwiki@gmail.com> Date: Sat, 12 Apr 2008 08:34:55 ------------------------------------------------------------------------------- Query completed, posted results on the enwiki page as requested.
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: sxwiki@gmail.com CC list: nospam@vyznev.net, sxwiki@gmail.com