Closed posted by users within specific creation date

1

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 *
FROM PostsWithDeleted p
INNER JOIN Users u ON u.Id = p.OwnerUserId
WHERE convert(date, u.CreationDate) = convert(date, ##regDate:string##) 
AND convert(date, p.CreationDate) >= convert(date, ##Start:string##)
AND convert(date, p.CreationDate) <= convert(date, ##End:string##)
AND p.ClosedDate IS NOT NULL
ORDER BY u.Id, convert(date, p.CreationDate)

Enter Parameters

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