Topic on Talk:Quarry

Jump to navigation Jump to search
Summary by Halfak (WMF)

Query completed :)

Mr. Fulano (talkcontribs)

Hi, what is the parameter to discovery while users create more pages in a wiki?

Halfak (WMF) (talkcontribs)

Hmm... It'll be hard to do over-all (for performance reasons), but it's pretty easy to check how many page creations were done in the last 30 days. The recentchanges table has that information.

  • rc_type = 1 limits the query to new page creations
  • rc_namespace = 0 limits he query to article namespace

Here's the top 10 article-page creators in the last 30 days:

rc_user_text COUNT(*)
DBD 2207
Wilhelmina Will 2046
Sesamehoneytart 1873
Lugnuts 1030
Ss112 939
AnomieBOT 904
Lithopsian 819
Matthiaspaul 793
Chubbles 763
SchreiberBike 703
Mr. Fulano (talkcontribs)

Thank you, I did this!