7
votes
SO Dataset query to retrieve questions, related answers and comments with a specific question tag
You're right, tags (and title and number of views) are only stored for questions, not answers. That means that for answers, you need to JOIN the Posts table with itself, like this query.
Because the ...
GlorfindelMod
- 211k
4
votes
SO Dataset query to retrieve questions, related answers and comments with a specific question tag
As already mentioned by Glorfindel, one thing which could make your queries faster is using the table PostTags. Some examples: questions, answers. (Notice that for answers we have to use ParentId and ...
- 12.4k
Only top scored, non community-wiki answers of a minimum length are eligible