Wikipedia talk:Non-local images
Appearance
![]() | This page was nominated for deletion on 23 September 2012. The result of the discussion was mark historical. |
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 (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://wiki.riteme.site/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
[edit]When is this going to be updated? —Preceding unsigned comment added by JesseW (talk • contribs) 17 November 2004