0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select p.Id,p.CreationDate,u.DisplayName, p.Score, p.Id AS [Post Link], pP.AcceptedAnswerId
from posts p,users u, posts pP where p.PostTypeId=2 
and 
( 
p.owneruserid=460686 
or p.owneruserid=461729
or p.owneruserid=464067
or p.owneruserid=469845
or p.owneruserid=462472
or p.owneruserid=475392
or p.owneruserid=360872
or p.owneruserid=477535
or p.owneruserid=477518
or p.owneruserid=477541
or p.owneruserid=485144
or p.owneruserid=494031
or p.owneruserid=497846
)
and p.owneruserid=u.Id
and p.ParentId=pP.Id
and p.CreationDate >= '2018-11-04'
and p.CreationDate < '2018-11-11'
order by CreationDate asc

view current version

edited nov 26 18

created jul 11 18 Tomasz.Buzaa