Last modified: 2014-01-03 15:59:02 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-123. Summary: Create list of pages in ruwiki, matching the regexp Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: Hoo man <hoo@online.de> ------------------------------------------------------------------------------- From: Peni <p.golik@gmail.com> Date: Wed, 02 Feb 2011 15:41:18 ------------------------------------------------------------------------------- After a long and extremely difficult discussion about renaming the article "Belarus" (see http://ru.wikipedia.org/wiki/%D0%92%D0%B8%D0%BA%D0%B8%D0%BF%D0%B5%D0%B4%D0%B8%D1%8F:%D0%9A_%D0%BF%D0%B5%D1%80%D0%B5%D0%B8%D0%BC%D0%B5%D0%BD%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D1%8E/24_%D1%81%D0%B5%D0%BD%D1%82%D1%8F%D0%B1%D1%80%D1%8F_2010 for details), we need to rename all other pages using the old transcription "Belorusiya". For this purpose, we would like to have a list of all pages (all namespaces: articles, templates, categories etc.) in ruwiki with the title matching any of the following regexps (case independent): ***Белорусс*** ***Беларус*** for further processing with our own bots. I think, this should be easy to solve with one single SQL query. Thank you! --[[:ru:user:Peni]]
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Wed, 02 Feb 2011 17:26:04 ------------------------------------------------------------------------------- SQL: SELECT page_namespace as ns, page_title as page FROM page WHERE page_title LIKE "%Белорусс%" OR page_title LIKE "%Беларус%"; Result: http://toolserver.org/~hoo/dbq/dbq-123.txt
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: hoo@online.de CC list: hoo@online.de