DBQ-123 Create list of pages in ruwiki, matching the regexp
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 3:58 PM

Description

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]]

Version: unspecified
Severity: major

Details

Reference: bz59376

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:26 AM

• bzimport added a project: Tool-Database-Queries.

• bzimport set Reference to bz59376.

JiraBugConverter created this task.Jan 3 2014, 3:58 PM

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

DBQ-123 Create list of pages in ruwiki, matching the regexpClosed, ResolvedPublicActions