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 ...
user avatar
  • 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 ...
user avatar
  • 12.4k

Only top scored, non community-wiki answers of a minimum length are eligible