Last modified: 2014-10-14 10:52:54 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-204. Summary: SQL query for pages created on dates between October 2011 and March 2013 Issue type: Task - A task that needs to be done. Priority: Major Status: Open Assignee: John R. Frank <jrf@mit.edu> ------------------------------------------------------------------------------- From: John R. Frank <jrf@mit.edu> Date: Thu, 21 Mar 2013 16:57:56 ------------------------------------------------------------------------------- Would it be possible for someone to run a SQL query for pages created on dates between October 2011 and March 2013 in the English Wikipedia? This would be very helpful to the TREC KBA research effort at NIST: http://trec.nist.gov/ http://trec-kba.org Any text format output is fine. Just need the page creation date and the URL. For example: 2011-10-02T04:04:03Z http://en.wikipedia.org/wiki/Interesting_Topic1 2011-10-02T04:05:03Z http://en.wikipedia.org/wiki/Interesting_Topic2 If the date range is challenging, then limiting to pages created in 2012 or the even just the first half of 2012 would be still be very helpful. Thank you for your help! Regards, John jrf@mit.edu
This query request is old. If you no longer require this query to be run, please close this bug as WONTFIX. Thanks!
I'll note that for most bugs in this component, someone can setup a query at quarry.wmflabs.org and that should be enough.
Closing this old request as WONTFIX. Please reopen this bug, or leave a comment, if you would still like this task to be completed.