0

Please login or register to vote for this query.

(click on this box to dismiss)

Preguntas y respuestas para programadores y profesionales de la informática

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=469845
or p.owneruserid=475392
or p.owneruserid=360872
or p.owneruserid=477535
or p.owneruserid=477518
or p.owneruserid=494031
or p.owneruserid=497846
or p.owneruserid=511418
or p.owneruserid=511923
or p.owneruserid=513968
or p.owneruserid=461729
or p.owneruserid=517692
or p.owneruserid=515276
or p.owneruserid=525879
or p.owneruserid=527253
or p.owneruserid=529478
or p.owneruserid=504596
or p.owneruserid=529873
or p.owneruserid=542573
or p.owneruserid=544933
or p.owneruserid=545585
or p.owneruserid=545145
or p.owneruserid=545622
or p.owneruserid=545600
or p.owneruserid=545721
or p.owneruserid=545593

)
and p.owneruserid=u.Id
and p.ParentId=pP.Id
and p.CreationDate >= '2019-11-10'
and p.CreationDate < '2019-11-16'
order by CreationDate asc

fork query

edited nov 18 anonymous

created apr 29 BlackBacardi