select posts.id as [Post Link] from posts left join posth...

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Great Outdoors

Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment

select posts.id as [Post Link] from posts
left join posthistory on PostHistoryTypeId = 52 and posts.id = postid
where posts.creationdate > '2019-02-28' and posts.creationdate <'2019-04-07' and PostTypeId =1
and posthistory.id is  null

Enter Parameters

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