0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT
  T.TagName, 
  T.WikiPostId as Wiki, 
  T.ExcerptPostId as Excerpt,
  T.Count as Questions,
  SE.Comment
From
  Tags as T
  right join SuggestedEdits as SE on 
  SE.Id = T.WikiPostId or SE.Id = T.ExcerptPostId
where
  (
    T.WikiPostId is null 
    or 
    T.ExcerptPostId is null
    or
    (
      SE.ApprovalDate is null
      and
      SE.RejectionDate is null
    )
  )
  and
  T.TagName like ##TagName:string?google-%##
ORDER BY
  Questions desc

view current version

edited jun 17 20

created jun 17 20 0Valt