SELECT Posts.Id as qid, LEN (Posts.title) AS qtl, LEN (Po...


Please login or register to vote for this query.

(click on this box to dismiss)


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

SELECT Posts.Id as qid,
       LEN (Posts.title) AS qtl,
       LEN (Posts.Body) AS qbl,
       Posts.CommentCount as qcc,
       Posts.FavoriteCount as qfc,
       Users.Id as uid,
       Users.Reputation as ur,
       Posts.AnswerCount as qac,
       Posts.Score as qsm,
       DATEDIFF(second, '1970-01-01 00:00:00', Posts.CreationDate) as qt,
       Posts.Tags as tags
  FROM Posts, PostTypes, Users
 WHERE     Posts.PostTypeId = PostTypes.Id
       AND Posts.OwnerUserId = Users.Id
       AND PostTypes.Name = 'Question'
       AND Posts.CreationDate > '2020-01-01'
       AND Posts.CreationDate < '2020-12-31'
       AND Posts.ClosedDate IS NULL
       AND Posts.Tags LIKE '%<sql>%'
       AND Posts.Tags LIKE '%<oracle>%'

Enter Parameters

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