SELECT Posts.Id,Posts.Title,Posts.Score,Posts.AnswerCount...

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 Posts.Id,Posts.Title,Posts.Score,Posts.AnswerCount,Posts.CommentCount,Posts.FavoriteCount, Users.Id, Users.DisplayName, Users.Reputation
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>%'
ORDER BY Posts.Id

Enter Parameters

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