SELECT que.Id as qid, que.PostTypeId as ptid, LEN (que.ti...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Vegetarianism

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

SELECT que.Id as qid,
       que.PostTypeId as ptid,
       LEN (que.title) AS qtl,
       LEN (que.Body) AS qbl,
       que.CommentCount as qcc,
       que.FavoriteCount as qfc,
       que.AnswerCount as qac,
       que.Score as qs,
       DATEDIFF(second, '1970-01-01 00:00:00', que.CreationDate) as qt,
       DATEDIFF(second, '1970-01-01 00:00:00', que.ClosedDate) as qct,
       que.Tags as tags,
       Users.Id as uid,
       Users.Reputation as ur
  FROM Posts que, Posts ans, PostTypes, Users
 WHERE     que.Id = ans.ParentId
       AND que.PostTypeId = PostTypes.Id
       AND que.OwnerUserId = Users.Id
       AND PostTypes.Name = 'Question'
       AND que.CreationDate > '2009-02-18'
       AND que.CreationDate < '2009-06-07'
       AND que.ClosedDate IS NULL
ORDER BY que.Id

Enter Parameters

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