User:Kotepho/reports/Images in pages in Cat: User templates

From Wikipedia, the free encyclopedia

< User:Kotepho | reports

select il.il_to, cl.cl_from, cl.cl_sortkey INTO OUTFILE 'images.txt' FROM categorylinks AS cl INNER JOIN imagelinks as il ON cl.cl_from = il.il_from WHERE cl.cl_to = 'User_templates'; and a little perl for formatting. Produced from the latests database dumps available, 5-18-2006. (OK, that wasn't the latest, but http://download.wikimedia.org/enwiki/latest which... wasn't the latest. Funny,eh?)