StackEx Answers Given timeframe

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A for administrators, end users, developers and designers for Craft CMS

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=9521610
or p.owneruserid=9928809
or p.owneruserid=3156333
or p.owneruserid=9892073
or p.owneruserid=9929015
or p.owneruserid=10347794
or p.owneruserid=10706312
or p.owneruserid=11102471
or p.owneruserid=11101419
or p.owneruserid=11148139
or p.owneruserid=9485673
or p.owneruserid=11300382
or p.owneruserid=11207414
)
and p.owneruserid=u.Id
and p.ParentId=pP.Id
and p.CreationDate > '2019-06-10'
and p.CreationDate < '2019-06-14'
order by CreationDate asc

Enter Parameters

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