Time for first comment

0

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

select p.Id AS [Answer ID], p.CreationDate AS [Answer Timestamp], c.PostId AS [Comment ID], c.CommCreationDate AS [Comment Timestamp]
from posts p
LEFT JOIN (select PostId,min(CreationDate) AS [CommCreationDate] from Comments group by PostId) c ON p.Id = c.PostId
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.CreationDate >= '2020-01-01'
and p.CreationDate < '2020-03-07'
order by p.CreationDate asc

Enter Parameters

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