3. Orphaned tag wiki
This are the wiki texts for tags that are removed by the clean-up script. When the tag is removed (because no questions have the tag anymore) you can no longer reach the wiki.
4. Tag wiki excerpt
This is the tag excerpt for a tag, you see the text in the box at the top of the page. To know which post belongs to which tag you'll find the foreignkeys in the tag table, for example:
, e.body as excerpt
, w.body as wiki
from tags t
inner join posts e on e.id = t.excerptpostid
inner join posts w on w.id = t.wikipostid
5. Tag wiki
This posts row holds the wiki text for a tag. You can use the above query to find the wiki post that belongs to a tag.
6. Moderator nomination
When an election is run, candidates provide a small nomination text. For each candidate you'll find a post. On a site you'll find previous elections under the
/election/[number] endpoint, for example https://stackoverflow.com/election/5. By limiting the query on the creationdates of the post you'll find the nomination texts for the candidates of that specific election.
, owneruserid as [User Link]
where posttypeid = 6 -- nominations
and creationdate between '2014-02-10'
7. "Wiki placeholder"
The posts with this type contain at least the text found at the election page. Their is only one post (so if you go to the first election, you'll find the same text).
Another post is used on the Tour page as the pay-off, and for the do ask and don't ask texts of the tour.
-- election and tour
select id, score, body
where posttypeid = 7 -- placeholder
8. Privilege wiki
Posts of this type hold the text for the privileges found for example here. Strangely enough for Stack Overflow only 2 privileges seem to have records. I guess all sites use the network wide defaults for the privileges and only add a post of type 8 if they have slightly different guidance for a privilege. On Super User only one privilege post exist.
I have all above queries captured here in case you want to investigate further. Keep in mind there are differences between what is in [SEDE] and what is in the DataDump, where the former is more complete.