Thanks you all for the tips. Maybe you have a good tip to get the parsed/html version of these entries in an easy way? Thanks again Sebastien On 9 January 2012 10:51, Jérémie Roquet &lt;arkanosis(a)gmail.com&gt; wrote: Hi Sebastien, 2012/1/9 Sébastien Druon &lt;druon.sebastien(a)gmail.com&gt;om>: (words) of a list of all the You can download the last dump¹ and pass it through a simple awk script that prints the titles of the pages that contain the {{-ru-}} template, ie. something like: ----8<---- BEGIN { ru = 0 } END { if (ru) { print title } } /<title>.*?</ { if (ru) { print title } title = substr($0, 12, length($0) - 19) ru = 0 } tolower($0) ~ /{{-ru-}}/ { ru = 1 } ----8<---- You'd still have to filter the output to only keep titles in the main namespace. It should be possible using categories too, but this wouldn't be any easier nor more reliable and would be much slower. Best regards, ¹http://dumps.wikimedia.org/ruwiktionary/20120107/ruwiktionary-20120107-pag… -- Jérémie _______________________________________________ Xmldatadumps-l mailing list Xmldatadumps-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/xmldatadumps-l

On 09/01/12 10:51, Jérémie Roquet wrote: I disagree. You would only need the much smaller ruwiktionary-20120107-category.sql.gz + ruwiktionary-20120107-page.sql.gz