Last modified: 2014-01-03 13:13:16 UTC
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: 1. Ends with a question mark 2. Begins with "How", "Why", or "What" (case insensitive) No urgency here. Thanks, – Shirik
------------------------------------------------------------------------------- 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