Jump to content

Wikipedia talk:Non-local images

Page contents not supported in other languages.
From Wikipedia, the free encyclopedia

Query

[edit]

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 (talkcontribs) 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

[edit]

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