DBQ-18 Placeholder image usage on enwiki
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 3:32 PM

Description

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

Version: unspecified
Severity: major

Details

Reference: bz59274

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:20 AM

• bzimport added a project: Tool-Database-Queries.

• bzimport set Reference to bz59274.

JiraBugConverter created this task.Jan 3 2014, 3:32 PM

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

DBQ-18 Placeholder image usage on enwikiClosed, ResolvedPublicActions