I'm doing some analysis on the wikipedia image metadata and seeing some missing image rows in the sql dumps.

I downloaded enwiki-latest-image.sql, enwiki-latest-imagelinks.sql, enwiki-latest-imagelinks.sql and enwiki-latest-oldimage.sql from http://dumps.wikimedia.org/enwiki/latest/

I picked a page, 25041, http://en.wikipedia.org/wiki/Special:Export/Lockheed_P-38_Lightning

I get 39 links from

"select il_to from imagelinks where il_from = 25041"

When I query the image table for these, only 8 of the 39 appear.

Some of the missing files are 050218-F-1234P-076.jpg, 020930-O-9999G-017.jpg

I can see the original file here though:

http://en.wikipedia.org/wiki/File:050218-F-1234P-076.jpg
--
@tommychheng