Topic on Talk:Quarry

Recentchanges table getting cleared?

3
Abbe98 (talkcontribs)

I'm not able to get items from the recentchanges table that have a timestamp value prior to January 2018. Is this table getting cleared? How would I retrieve changes prior to January 2018?

Example COUNT query of recentchanges(last run in 2017): https://quarry.wmflabs.org/query/23105

Returned 136380 rows.

The same query that I ran today: https://quarry.wmflabs.org/query/25408

Returned 1720 rows

Thanks!

Edgars2007 (talkcontribs)
Abbe98 (talkcontribs)

Thanks! that explains the difference between "revisions" and "recent changes" ;-)