Wikipedia talk:Non-local images

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)

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