Data Explorer (SEDE)

« first day (30 days earlier) ← previous day next day → last day (2067 days later) »

7:01 AM

I suppose this query should return some information about PostNotices table: data.stackexchange.com/stackoverflow/query/472607/…

It is linked from Database schema documentation for the public data dump and SEDE

But when I run it I get 0 rows. Is that supposed to happen?

2 hours later…

Feeds

9:09 AM

Q: Top voted questions not voted by me

How can I get top voted questions by tag, that are not voted by me (down/up). Can you help me with a SEDE query, or easier solution?

1 hour later…

Martin

10:33 AM

Here is my attempt also I am pretty sure it can be improved: Top voted questions without my answer.

To test it, I have used a site and tag where I have several answers: For comparison here are questions with my answer: Questions in a given tag with my answer

I am pretty sure that it can be improved in various ways, but I have at least tried to create some query concerning your edited question - you can see it in the SEDE chatroom. — Martin 7 secs ago

Just to clarify, this is not about original question, but about the request edited into the question later:

> To get top voted questions by tag, that are not answered by me.

Khemraj

10:52 AM

@Martin This is working perfectly, thank you so much.

Martin

11:03 AM

I should probably have included ViewCount. But I suppose it is not that difficult to modify the query if you want to have the questions sorte by views.

@Khemraj We will see whether some of the users more experienced with SEDE will have some suggestion. In any case, I do not see how the original question could be implemented - but this has already been mentioned in the comments.

SEDE can't see how you voted. You can get the top voted questions questions per tag though. — Robert Longson 2 hours ago

1 hour later…

Martin

12:06 PM

Q: Reputation points earned solely by asking questions

During the recent moderator election I found myself wondering if there are any high-rep users (> 10K) who have amassed that many reputation points solely by asking questions and not by answering any. I'm not interested in identifying particular users, but do we have a way of finding the highest ...

discussion reputation

Using data explorer you can find users with highest total score from answers and from questions. Total score is different from reputation earned (for example, it does not take into account reputation cap), but it is a rough approximation. — Martin Sleziak yesterday

Edit I have spent some time trying to convert the two Data Explorer queries that Marting posted into one that would do what I want. My SQL skills aren't great, however, and I have so far been unsuccessful.

@PeterPhipps Would you clarify a bit what exactly do you want to achieve "by combining two queries into one"? It's a bit unclear to me what exactly you're looking for. If you wish, we can discuss this further in the SEDE chatroom so that we do not leave too many comments here. — Martin Sleziak 1 min ago

Maybe I originally misunderstood the question.

Perhaps you want high rep users that have zero answers or at least zero upvoted answers?

Peter Phipps

12:25 PM

Hi Martin. I was trying to combine the question and answer queries into one that selected users with an answer score of zero and then ordered by question score.

Martin

Here is a query which lists users together with their total score and total count of questions/answers: data.stackexchange.com/math/query/891027/…

@PeterPhipps This might be at least approximation of what you want: Top user with no answers and Top users with zero score from answers

Still, for example this user is listed there - all their answers are upvoted but one of them is accepted, so they earned reputation from the accepted answer.

I suppose that it would be possible to modify query somehow to count additionally also number of accepted answer, but it seems to me that I would need to include somehow one more join and the query becomes more complicated.

And I wouldn't be surprised if we find out that I've made a mistake somewhere in the queries linked above.

We will see whether some of the more experienced users notice either your question on meta or the conversation here in chat - possibly somebody will suggest better queries than what I did above.

Peter Phipps

@Martin, The "Top users with zero score from answers" query seems to be what I want, thank you. Including accepted answers is getting too complicated.

Martin

12:42 PM

BTW another thing which this query ignores (and which influences reputation) is CW posts.

I suppose that it's expected that some of the users who posted highly upvoted questions should appear among the top results, indeed I see some name from the query when I search for highly upvoted questions directly on the site.

rene

@Martin slightly adapted so you you don't need an Exists and eliminated a fulltable can on the posts table. data.stackexchange.com/sports/query/891034/…

Martin

I see - the part following left outer join in your query replaces what I did using NOT IN (SELECT.....

@Khemraj See above for a modified query.

If I understand that correctly, your query returns top questions if I input a non-existent userId.

Khemraj

1:09 PM

@Martin Okay

1 hour later…

Peter Taylor

2:30 PM

@Martin There is one change which doesn't seem to have any downside and simplifies the query: remove the join to the Users table, which isn't necessary: data.stackexchange.com/math/query/891056/…

Martin

2:44 PM

@PeterTaylor Thanks, I completely missed this! @PeterPhipps see above for a simplification of the query I posted before.

2 hours later…

Martin

4:50 PM

A: Reputation points earned solely by asking questions

I rewrote query by Martin Sleziak into this: https://data.stackexchange.com/math/query/891053/top-users-with-no-answer-scores?num=100 Hope it helps. If still joining on users, you can explicitly view reputation: https://data.stackexchange.com/math/query/891096/top-reputation-users-with-no-ans...