Using SEDE I'm trying to get the TagWiki
s along with their corresponding Tags
.
This is what I tried (but i get an empty result):
select Body,TagName from Posts
inner join PostTags on PostTags.PostId=Posts.Id
inner join Tags on Tags.id=PostTags.TagId
where PostTypeId=5
https://data.stackexchange.com/stackoverflow/query/68737
Getting the TagWiki
s alone is no problem, using something like:
select top 10 * from Posts
where PostTypeId=5
https://data.stackexchange.com/stackoverflow/query/68733
But in the PostTags
table there is no corresponding PostId
for Posts
with PostTypeId=5
, so this query returns an empty result:
select * from Posts
inner join PostTags on PostTags.PostId=Posts.Id
where PostTypeId=5
https://data.stackexchange.com/stackoverflow/query/68711
Is there a way to accomplish this? (or am I just missing something obvious?)
PostTags
entries for tag wikis, or ifTags
is meant to have foreign keys toPosts
for the excerpt and body...