Stack Exchange
log in
help
Stack Exchange Data Explorer
Home
Queries
Users
Compose Query
Magisch
Registered User
member for
2848 days
seen
Feb 19 '20 at 9:39
website
https://stackoverflow.com/users/5389107/magisch
location
Germany
edited
favorite
recent
SELECT CAST((SUM(pd.Questions) * 1.00 / COUNT(pd.Date)) ...
Reputation Gained until a Certain Date
[Query to identify serial Upvoting] [v2.3]
SELECT COUNT(*) FROM Votes WHERE VoteTypeId = 5
[Query to detect unusual answer and question correlations] [v0.1]
SELECT TOP 10 * FROM Votes WHERE VoteTypeId = 1 ORDER BY ...
SELECT bad.Name, us.Id AS [User Link], us.DisplayName FR...
[Query to identify voting Rings] [v2.0]
SELECT vdt.User_ID AS [User Link], ( 'site://users/' ...
SELECT SUM((CASE WHEN p.Score >= 10 THEN 1 ELSE 0 END)) A...
Posts by a specific user where the last comment was made by another specific user
SELECT * FROM PostsWithDeleted
SELECT * FROM Users
Questions per Day on IPS on a Monthly Basis
Questions/Answers per Day on a Weekly Basis
1
2
3
next
Data Explorer works best with JavaScript enabled