DBQ-86 List of deleted pages in the form of a question
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 1:13 PM

Description

This issue was converted from https://jira.toolserver.org/browse/DBQ-86.
Summary: List of deleted pages in the form of a question
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: (none)

From: Matthew P. Del Buono <delbu9c1@my.erau.edu>

Date: Sun, 07 Feb 2010 03:21:45

I'm trying to evaluate the abuse filter request here:

http://en.wikipedia.org/wiki/Wikipedia:Edit_filter/Requested#New_article_title_in_the_form_of_a_question

Because performance considerations of the filter are important, I want to get an idea for what kind of hit rate we'd be talking about here (if it's too low, then there's no sense in making the filter). I'd like a query to be run to tell me a list (or just a total quantity) of deleted pages whose titles match one of the following:

Ends with a question mark
Begins with "How", "Why", or "What" (case insensitive)

No urgency here.

Thanks,
– Shirik

Version: unspecified
Severity: major

Details

Reference: bz59250

Event Timeline

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

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

• bzimport set Reference to bz59250.

JiraBugConverter created this task.Jan 3 2014, 1:13 PM

From: MZMcBride <mzmcbride@gmail.com>

Date: Sun, 07 Feb 2010 03:37:18

mysql> SELECT

    ->   COUNT(*)
    -> FROM logging_ts_alternative
    -> WHERE log_namespace = 0
    -> AND log_type = 'delete'
    -> AND log_action = 'delete'
    -> AND log_title LIKE '%?';
+----------+
| COUNT(*) |
+----------+
|     6490 | 
+----------+
1 row in set (4 min 55.33 sec)

mysql> SELECT    ->   COUNT(*)
    -> FROM logging_ts_alternative
    -> WHERE log_namespace = 0
    -> AND log_type = 'delete'
    -> AND log_action = 'delete'
    -> AND log_title RLIKE '^(What|How|Why)_.*';
+----------+
| COUNT(*) |
+----------+
|     6702 | 
+----------+
1 row in set (31.95 sec)

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: (none)
CC list: b@mzmcbride.com, delbu9c1@my.erau.edu

DBQ-86 List of deleted pages in the form of a questionClosed, ResolvedPublicActions