All Questions
22
questions
4
votes
1
answer
51
views
Query to get users with highest number of sites with at least one famous question
I want to know who are the top users across all sites in terms of number of sites in which they've got at least one famous question (so, count is across sites, not across famous questions).
I know ...
4
votes
1
answer
100
views
Write a query to get top rep. users who have silver badges, but no gold ones
I am trying to compose a query that will list all high rep users who have a silver badge, but no gold ones.
I am new to the SEDE. I have gone through the tutorial and properties documentation, but I ...
6
votes
1
answer
73
views
Edit counts toward Strunk & White badge do not always add up to 80
There are a number of similar questions but they don't seem to capture the following: There is a list of criteria for edits that do / do not count towards the Strunk & White badge; however, when I ...
4
votes
1
answer
58
views
Why is there some data unaccessible from the Data Explorer? [duplicate]
I was wondering why I didn't get the Unsung Hero badge when I theoretically should have it on Stack Overflow.
The How Unsung am I? requests shows only 10 unscored answers, the real count is 11 but ...
4
votes
1
answer
131
views
How to select users with a gold Angular badge
I'm using the following query on SEDE to select top 100 users with angular gold badge:
SELECT TOP 100 UserId AS [User Link], COUNT(*)
FROM Badges
WHERE Name IN ('angular')
GROUP BY UserId
ORDER BY ...
1
vote
0
answers
56
views
Strange behavior in unsung hero query
I recently notice that I'm close to get the Unsung Hero Badge so I run this query
How Close Am I to Unsung Hero Badge (Including 10 days requirement)? with my userId 4848308 and I get as result
| ...
2
votes
0
answers
55
views
How to retrieve "badge type" in Data Explorer?
I'm trying to write a query (Badge Order Received) on the Stack Exchange Data Explorer, within whose results I want to link to a user's awards of a given badge. On Stack Overflow, such a link may be ...
2
votes
1
answer
59
views
Using SEDE to track progress on the Electorate badge
Almost identical to this SEDE query, I was trying to query for all my votes and determine how many were on questions, answers, and comments. Starting simply, I wanted to grab all my votes and their ...
6
votes
1
answer
86
views
Are there any other requirements for the Taxonomist badge?
Both this query as well as this say that I am the creator of the soundtrack tag on Movies & TV. But while the tag already has 82 questions associated to it, I haven't yet been awarded the ...
1
vote
1
answer
94
views
Is there a query on SEDE that returns the questions eligible for the asking days badges?
Is there any query on Stack Exchange Data Explorer (SEDE) that retrieves the questions which are eligible for the asking days badges (curious, inquisitive and socratic)? I could not find one*.
There ...
4
votes
1
answer
96
views
Question about Archaeologist progress query
First google result points to this query named: What is my Archaeologist badge progress?
It returns 7 for me although I am quite positive I have edited more than 7... I may be wrong...
So, if I go to ...
1
vote
1
answer
102
views
Is there a delay in being awarded the generalist badge?
According to this query, I should have been awarded the Generalist badge, but I haven't.
Presumably if the data is on data explorer, it should be calculated on the live site as awarded.
Assuming the ...
2
votes
0
answers
50
views
How to get type of the badge (Bronze, Silver, Gold) from Data Explorer? [duplicate]
I was just curious who have the most Gold, Silver or Bronze badges but I can't find the field in Data Explorer that represents the type of the badge. Either it's missing or I can't find it.
So, how ...
1
vote
2
answers
533
views
Badge Statistics and maximum number of badges on Stack Overflow
We can see statistics about reputation at https://stackexchange.com/leagues/1/alltime/stackoverflow.
How can I find who had maximum number of badges on Stack Overflow ? It would be nice to see ...
10
votes
2
answers
311
views
A query to get all posts that count for Archaeologist and Excavator
I've been playing with data-explorer to peruse stackoverflow more and learn some t-sql.
I managed to write this query, which lists out all posts the user has edited and then shows a difference in ...