select u.Id as [User Link], a.Id as [Post Link], a.Body, ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ukrainian Language Meta

Q&A about the site for linguists, teachers and students of the Ukrainian language

select u.Id as [User Link], a.Id as [Post Link], a.Body, u.CreationDate as [Account Created], a.CreationDate as [Answer Created], q.CreationDate as [Question Created]
--,u.*, a.*
from posts a
join users u on a.OwnerUserId = u.Id
join posts q on a.ParentId = q.Id
join posttags pt on q.Id = pt.PostId
and not exists (select NULL from tags t where pt.TagId = t.Id and t.TagName = 'jq')

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results