0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

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
where 1=1
and u.Id = 11385808
and not exists (select NULL from tags t where pt.TagId = t.Id and t.TagName = 'jq')

fork query

edited may 23 19

created apr 1 19 anonymous