Wikipedia talk:Non-local images

This page was nominated for deletion on 23 September 2012. The result of the discussion was mark historical.

Query

List produced by query: SELECT cur_title from cur where cur_namespace=0 and cur_text regexp "[^[]http://[a-z0-9_/%+:.-]+.(jpg|jpeg|png|gif)" order by cur_title
—Preceding unsigned comment added by Brion VIBBER (talk • contribs) 03 November 2002

This query will also produce pages that have HTTP links to images on Wikipedia. For example, some articles have a small or low resolution picture within the article and a link to a bigger or higher resolution version. To exclude these, I suggest using the following query instead:

SELECT cur_namespace, cur_title FROM cur 
 WHERE cur_namespace=0 
 AND ( cur_text REGEXP "[^[]http://[a-z0-9_/%+:.-]+.(jpg|jpeg|png|gif)" 
   AND cur_text NOT LIKE "%http://en.wikipedia.org/wiki/Image:%"  )
 ORDER BY cur_title

This reduced the list by about 200 for the 08 February 2006 database dump. -- JLaTondre 14:20, 20 February 2006 (UTC)[reply]

Updates

When is this going to be updated? —Preceding unsigned comment added by JesseW (talk • contribs) 17 November 2004