0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for community managers, administrators, and moderators

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=11101419
or p.owneruserid=7090016
or p.owneruserid=12153576
or p.owneruserid=12257134
or p.owneruserid=12201084
or p.owneruserid=11977760
or p.owneruserid=1466573
or p.owneruserid=11207414
or p.owneruserid=11714114
or p.owneruserid=11602913
or p.owneruserid=11102471
or p.owneruserid=9928809
or p.owneruserid=12237732
or p.owneruserid=11300382
or p.owneruserid=12014434
or p.owneruserid=3156333
or p.owneruserid=11148139
or p.owneruserid=10347794
or p.owneruserid=12186585
or p.owneruserid=9929015
or p.owneruserid=9521610
or p.owneruserid=12257250
or p.owneruserid=11560878
or p.owneruserid=10892354
or p.owneruserid=10161306
or p.owneruserid=12410332
or p.owneruserid=12428794
or p.owneruserid=12524159
or p.owneruserid=11901958
or p.owneruserid=12571387
or p.owneruserid=12518487
or p.owneruserid=12767257
or p.owneruserid=12857703
)
and p.owneruserid=u.Id
and p.ParentId=pP.Id
order by Score desc

fork query

edited sep 24 20 anonymous

created apr 29 19 BlackBacardi