Orphaned tag wikis

0

Please login or register to vote for this query.

(click on this box to dismiss)

Statistical Analysis

Q&A for people interested in statistics, machine learning, data analysis, data mining, and data visualization

select concat('site://posts/', p.Id, '/revisions|orphaned ', pt.Name) Link, LastEditDate
from Posts p
join PostTypes pt on pt.Id=p.PostTypeId
where PostTypeId in (5,4)
and p.Id not in (select ExcerptPostId from Tags where ExcerptPostId is not null 
               union all 
               select WikiPostId from Tags where WikiPostId is not null) 
order by p.Id desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results