Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 158100

For questions about the functionalities, queries, databases and datamodel of The Stack Exchange Data Explorer (SEDE). SEDE allows you to create and run queries against copies of the databases of popular Stack Exchange sites.

45
votes
As far as I know, there is no visual representation of the database schema of the Data Explorer maintained, so I think this will be the first one. This is what I have after a couple of hours for writ …
answered Mar 1 '15 by rene
12
votes
The Stack Exchange Data Explorer now has a tutorial to get you started, the help states that SEDE runs on Microsoft SQL Server. When creating a query the right side shows the tables and columns avail …
answered Jun 15 '14 by rene
13
votes
0answers
The table reviewtasks is sanitized for deleted posts. This means that it is hard, if not impossible, for the users that care and for those that want to evaluate the effectiveness of a community to fin …
asked Aug 27 '16 by rene
10
votes
Let me answer on behalf of Nick Craver: Though we'll be a little rocky making this time until we're back in New York - it's when it should happen! For the curious: We have a kerberos pass-t …
answered Aug 30 '15 by rene
10
votes
1answer
I didn't notice this earlier but for some reason it looks like the query parameter functionality is broken for me when editing a query. If I run this query from the edit view declare @title nvarchar …
asked Apr 2 '15 by rene
10
votes
0answers
I was looking at some of the *-Types tables in the Stack Exchange Data Explorer. specially CloseAsOffTopicReasonTypes. As I'm lazy I clicked the (i) that is found in the right hand side of the SEDE q …
asked Jul 29 '18 by rene
9
votes
Ok, I found the root-cause. The field title is already submitted in the form. So if you choose your variable names don't use ones that are already part of the payload. this will work: declare @some …
answered Apr 2 '15 by rene
9
votes
0answers
Today I was working on a SEDE query when I was met with a somewhat unexpected error message: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CS_AS" and "SQL_Latin1_General_CP …
asked Feb 27 '16 by rene
9
votes
The following query would show that for a specific site: with userpostdates as ( select owneruserid , posts.creationdate , row_number() over (partition by owneruserid order by posts …
answered Dec 22 '14 by rene
7
votes
The following cross-site query does that for you. Do note that the Tags table doesn't have an description or excerpt field. Almost all texts within the database are as much as possible stored in the …
answered Dec 8 '16 by rene
7
votes
The use of a magic column like [User Link] in a query doesn't involve real magic but actually very hard work for the query plan processor. This is what happens in the SEDE internals. Once the maximum …
answered Aug 31 '16 by rene
6
votes
1answer
I left a comment on this question suggesting to try a cross-database query to get a reliable statistic (I did mention that it might run for too long but that is not the point). After seeing nicael's …
asked Mar 18 '15 by rene
7
votes
I believe this query will give you that number: select count(*) as [number of upvotes] from votes v inner join posts p on p.id = v.postid where v.votetypeid =2 -- upmod and p.owneruserid = ##userid: …
answered Aug 22 '15 by rene
27
votes
I fully support this request. If you don't mind hammer the SEDE database you can use this query that I forked from the original post. select top 100 sum(isnull(p.viewcount,0)) as reached …
answered Apr 16 '15 by rene
5
votes
With rev. 2015.4.22.34 the odata endpoints got hidden because they were dysfunctional for a long time. Your best option is the Stack Exchange API as indicated by Tim. Alternatively you could use on …
answered Apr 23 '15 by rene

15 30 50 per page