SELECT p.CreationDate, p.deletionDate, p.Id, p.Score, p.v...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Space Exploration

Q&A for spacecraft operators, scientists, engineers, and enthusiasts

SELECT p.CreationDate, p.deletionDate, p.Id, p.Score, p.viewCount, 
p.AnswerCount, p.Title, v.postid AS [Post Link], t.tagName FROM Posts p
INNER JOIN votes v on p.Id=v.postid
INNER JOIN PostTags pt ON pt.PostId = p.Id
INNER JOIN Tags t ON t.Id = pt.TagId

WHERE ( t.TagName = 'tensorflow' or t.TagName = 'tensorflow2.0' )
/*or t.TagName = 'tf.keras' or t.TagName = 'tensorflow-estimator') */
 /*   and p.AnswerCount = 0 */
and p.creationDate >= '2022-05-01' 
and  p.creationDate <= '2022-05-31'
/*    and p.Score > 0 */
GROUP BY p.Id, p.title,p.AnswerCount, p.CreationDate,p.deletionDate, p.Score, p.Tags, t.TagName, v.postid, p.viewcount
ORDER BY  p.CreationDate DESC

Enter Parameters

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