(quote taken from your deleted thread, now there's more to read again Cheesy

)

Quote from: DdmrDdmr on August 09, 2018, 11:21:53 AM

What Ive initially done is compare the database snapshots on merited user profiles for 06/08/2018 and 06/07/2018. I wanted to see how much people post on average on a daily basis for the month between the two snapshot dates.
~
I guess we wanted to see the list of posters in the "very heavy" user segment, so here it goes (NewPost -> number of posts in a month):

Code:

user_id name rank NewPost merit NewMerit url

~~"NewMerit" in your table is the total amount of Merit earned since its introduction, until last Friday. Shouldn't that be the amount of Merit earned in the period between those two profile snapshots?~~ This has been fixed.

Quote from: DdmrDdmr on August 09, 2018, 11:23:13 AM

a surprisingly high 17,77% have a decrement their post count during the month.

My guess would be Mods are more active lately cleaning up Spam Megathreads.

Quote

That is quite a lot, even more so considering that were talking about merited users.

Two days ago, I realized almost all 2053 accounts with exactly 10 Merit must have been Merit trading. I think I'll make a thread on this later, that's a very large percentage of all new Member accounts.
And if that's true, it doesn't surprise me many of them lose posts when Spam Megathreads are deleted.

Can you get me a list of all 1033 Member accounts that lost posts? I'd like to cross-reference them to the ones that earned exactly 10 Merit.