Benutzer:Luxo/Versuchslabor
Zur Navigation springen
Zur Suche springen
MySql Query: (anfrage.txt)
SELECT count(*)
FROM `page`
WHERE page_namespace=6
AND page_title REGEXP "^(DVC|CIMG|IMGP?|PICT|DSC[FN]?|DUW|JD|MGP|scan|untitled|foto|imagen|img|image|picture|p|BILD)+[0-9 \\-_]+\\..*"
Command
sql commonswiki_p < anfrage.txt > output.txt
Return (output.txt; Runtime ~3min)
count(*)
6111