select Posts.Title,Posts.AnswerCount,Posts.CommentCount,P...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Source Meta

Q&A about the site for people organizing, marketing or licensing open source development projects

select Posts.Title,Posts.AnswerCount,Posts.CommentCount,Posts.FavoriteCount, Users.*
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

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