Q&A for ebook publishers and readers
-- 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>%'