Hi All,
I downloaded enwiki-latest-pages-articles.xml from http://download.wikimedia.org/enwiki/latest/ and imported page.txt & revision.txt in my mysql database.
Now i am trying to extract groups of people who are editing same pages.
on the revision table i ran the following query, to see the page_id of pages that have been edited by more than one person.
mysql> select rev_page, count(rev_page) from revision group by rev_page having count(rev_page)>1; Empty set (1 min 19.24 sec)
I got an empty set back. I think this is not possible, as many pages are edited by multiple people in Wikipedia.
Can you please let me know if i am doing something wrong here??
I will be thankful for help
Best Regards,
On 10/20/07, Fawad Nazir fawad.nazir@gmail.com wrote:
Hi All,
I downloaded enwiki-latest-pages-articles.xml from http://download.wikimedia.org/enwiki/latest/ and imported page.txt & revision.txt in my mysql database.
Now i am trying to extract groups of people who are editing same pages.
on the revision table i ran the following query, to see the page_id of pages that have been edited by more than one person.
mysql> select rev_page, count(rev_page) from revision group by rev_page having count(rev_page)>1; Empty set (1 min 19.24 sec)
I got an empty set back. I think this is not possible, as many pages are edited by multiple people in Wikipedia.
Can you please let me know if i am doing something wrong here??
enwiki-latest-pages-articles.xml only has the "latest" version of each article.
Download the stub-meta-history.xml file. It doesn't contain the text of the versions, but it does contain the authorship information. Except, it doesn't currently exist. If you set me up with a place to upload it I can probably get you enwiki-20070908-stub-meta-history.xml.gz. Otherwise, wait until the next stub-meta-history file gets dumped, possibly in the next week or so if the current dump doesn't fail.
Hi Anthony,
Thanks for your reply. I will send you account details in a personal email to upload this file to.
-Fawad.
On 10/20/07, Anthony wikimail@inbox.org wrote:
On 10/20/07, Fawad Nazir fawad.nazir@gmail.com wrote:
Hi All,
I downloaded enwiki-latest-pages-articles.xml from http://download.wikimedia.org/enwiki/latest/ and imported page.txt & revision.txt in my mysql database.
Now i am trying to extract groups of people who are editing same pages.
on the revision table i ran the following query, to see the page_id of pages that have been edited by more than one person.
mysql> select rev_page, count(rev_page) from revision group by rev_page having count(rev_page)>1; Empty set (1 min 19.24 sec)
I got an empty set back. I think this is not possible, as many pages are edited by multiple people in Wikipedia.
Can you please let me know if i am doing something wrong here??
enwiki-latest-pages-articles.xml only has the "latest" version of each article.
Download the stub-meta-history.xml file. It doesn't contain the text of the versions, but it does contain the authorship information. Except, it doesn't currently exist. If you set me up with a place to upload it I can probably get you enwiki-20070908-stub-meta-history.xml.gz. Otherwise, wait until the next stub-meta-history file gets dumped, possibly in the next week or so if the current dump doesn't fail.
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/wikitech-l
wikitech-l@lists.wikimedia.org