I can run, I'll e mail you the result
On Thu, Mar 21, 2013 at 9:38 PM, John R. Frank jrf@mit.edu wrote:
but You can do it via SQL queries, It's simple:
http://www.mediawiki.org/wiki/**Database_layouthttp://www.mediawiki.org/wiki/Database_layout
That's very cool. I don't have toolserver access, so I cannot run it directly on en.wikipedia.org's SQL database. I created this ticket:
https://jira.toolserver.org/**browse/DBQ-204<https://jira.toolserver.org/browse/DBQ-204>Are any of you toolserver power users who could run this for us?
jrf
Text of ticket:
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_Topic1http://en.wikipedia.org/wiki/Interesting_Topic1 2011-10-02T04:05:03Z http://en.wikipedia.org/wiki/**Interesting_Topic2http://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
______________________________**_________________ Pywikipedia-l mailing list Pywikipedia-l@lists.wikimedia.**org Pywikipedia-l@lists.wikimedia.org https://lists.wikimedia.org/**mailman/listinfo/pywikipedia-lhttps://lists.wikimedia.org/mailman/listinfo/pywikipedia-l