0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for speakers of other languages learning English

-- Enter Query Title
-- Enter Query Description

select A.Id as [Post Link],
       A.CommunityOwnedDate,
       A.OwnerUserId as [User Link],
       A.OwnerDisplayName,
       Q.Tags as [Tags]
from Posts A, Posts Q
where A.ParentId = Q.Id
  and (A.CommunityOwnedDate is not null or Q.CommunityOwnedDate is not null)
  and A.PostTypeId = 2
  and Q.PostTypeId = 1
  and Q.Tags like '%<java>%'

view current version

edited jul 5 14

created jan 17 14 rolfl