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 ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
stack-overflow × 5394discussion × 3224
support × 1522
tags × 981
status-completed × 542
feature-request × 506
retag-request × 436
specific-question × 383
bug × 380
synonym-request × 237
questions × 224
burninate-request × 211
reputation × 201
tag-synonyms × 190
closed-questions × 133
review × 118
stack-exchange × 112
scope × 111
vote-to-close × 109
answers × 104
design × 79
reopen-closed × 79
status-bydesign × 78
asking-questions × 74
down-votes × 70