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)

Audio-Video Production Meta

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, posts q, users u, posttags pt, tags t
where 1=1
and u.DisplayName = 'Dmitry'
and a.OwnerUserId = u.Id
and a.ParentId = q.Id
and q.Id = pt.PostId
and pt.TagId = t.Id
and t.TagName = 'jq'

Enter Parameters

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