User:Krinkle/Queries/commonswiki filepageswithoutdots

commons.wikimedia.org : File-pages without dots
Last update: 2011-04-04 16:58 (UTC)

# file.sh
sql commonswiki_p < filepageswithoutdots.sql > commonswiki_filepageswithoutdots.txt

# filepageswithoutdots.sql
SELECT
 concat('*[[:commons:File:',page_title,']]')
FROM page
WHERE page_namespace=6
AND page_title NOT LIKE '%.%'
LIMIT 500

# commonswiki_filepageswithoutdots.txt