Topic on Talk:Quarry

Hi guys!

One more important question I forgot to ask..

I am also looking for "revision" table. Again- the same problem with large queries :)

So I looked in the dumps and found the following:

when searching "revision" I got to 2 dumps that I think might help me- "Recombine first-pass for page XML data dumps" and "First-pass for page XML data dumps"

What is the difference between them? they both state at the beginning "These files contain no page text, only revision metadata."

Also, when looking into these sections the files there are divided to 3: stub-meta-history,  stub-meta-current, stub-articles.

What is the difference between them in the means of what fields they include? of what sections in the site and of what time-frame?

My goal is to fetch for every user his whole edit history including- on which pages, how long was the edit, and the date of the edit.

Thanks for any help that may come! :)

I would advise to ask this specific question at enwiki w:WP:VPT, if nobody answers here.

Thanks,

I'll make sure to ask there now as well.

stub-meta-history

Contains metadata about revisions to all pages

stub-meta-current

contains metadata for only the most recent revision of all pages.

stub-articles

contains metadata for only the most recent revision of "content" pages (articles, templates, etc.)

Thank!

Therefore I understand stub-meta-history contains recent and old version together right?

That's right. :)