Questions by users with rep>1000

0

Please login or register to vote for this query.

(click on this box to dismiss)

English

Q&A for linguists, etymologists, and serious English language enthusiasts

SELECT 
    
    Users.Id as [User Link],
    Posts.Title as [Posts Link],
    Posts.LastEditDate,
    posts.creationdate,
    posts.closeddate,
    posts.acceptedanswerid,
    'http://english.stackexchange.com/questions/'+ cast(posts.id as nvarchar) 
    FROM
    Users
  INNER JOIN
    Posts ON Users.Id = OwnerUserId
WHERE 
Reputation >= 1000 AND Title != '' and posts.creationdate>getdate()-365 and closeddate is null and posts.acceptedanswerid is null
ORDER BY
    [LastEditDate] DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results