Last modified: 2014-10-14 10:52:54 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T61486, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 59486 - DBQ-204 SQL query for pages created on dates between October 2011 and March 2013
DBQ-204 SQL query for pages created on dates between October 2011 and March 2013
Status: RESOLVED WONTFIX
Product: Tool Labs tools
Classification: Unclassified
Database Queries (Other open bugs)
unspecified
All All
: Unprioritized normal
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-01-03 16:13 UTC by Bugzilla Bug Importer (valhallasw)
Modified: 2014-10-14 10:52 UTC (History)
2 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Bugzilla Bug Importer (valhallasw) 2014-01-03 16:13:12 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
Comment 1 This, that and the other (TTO) 2014-09-16 10:59:13 UTC
This query request is old. If you no longer require this query to be run, please close this bug as WONTFIX. Thanks!
Comment 2 Yuvi Panda 2014-09-16 11:03:59 UTC
I'll note that for most bugs in this component, someone can setup a query at quarry.wmflabs.org and that should be enough.
Comment 3 This, that and the other (TTO) 2014-10-14 10:52:54 UTC
Closing this old request as WONTFIX. Please reopen this bug, or leave a comment, if you would still like this task to be completed.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links