« first day (502 days earlier)      last day (1600 days later) » 

Sonic the Reinstate Monica-hog
Sonic the Reinstate Monica-hog
2:47 AM
@rene Is there an existing SEDE query to rank users by how long they took to achieve a given amount of rep, from the time they registered their account?
 
 
4 hours later…
rene
rene
7:11 AM
@SonictheReinstateMonica-hog don't think so but you can only do that from user.Creationdate to Now as we don't have reputationhistory records in SEDE.
I guess datediff(d, users.creationdate, GetDate())/users.reputation should give you a ratio you can use.
 
Martin
Martin
7:37 AM
When you mentioned that there is no reputation history in SEDE, that reminded me of your query here: How to receive detailed reputation from SEDE. (It gives some approximation of reputation breakdown. The usual caveat applies - not all events which influence reputation are actually recorded in SEDE.)
Also when Glorfindel posted here some queries which taken into account the reputation cap, I have tire a few queries here: chat.meta.stackexchange.com/transcript/1223/2019/11/23
Still, I suppose that all the queries mentioned above would take a long time if we wanted to run them for many users.
And for this purpose, they have to be modified. (All of them look at the reputation over the whole period, not only until some reputation was reached.)
 
 
3 hours later…
Feeds
Feeds
11:07 AM
0
Q: How to select comunity wiki questions?

Kamil KiełczewskiI want to write a query which selects the highest scored community-wiki questions (like this) but I don't have an idea how to do it. This is what I have so far https://data.stackexchange.com/stackoverflow/query/1166501/find-top-wiki-questions How to do it? It is also possible to select questio...

support data-explorer
 
Feeds
Feeds
12:01 PM
1
Q: How to select 'community wiki locked' questions?

Kamil KiełczewskiI want to write a query which selects the highest scored community-wiki-lock questions (like this one). This is not typical comunity-wiki question like this - but comunity-wiki-lock (e.g. we see there the original question author without 'wiki' info). For community-wiki it is enough to use Commun...

support data-explorer locked-questions
 

« first day (502 days earlier)      last day (1600 days later) »