Check when score was updated

0

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

SELECT p.Id, v.postid AS [Post Link], p.Score, p.viewCount, p.AnswerCount, p.title, t.tagName, p.creationDate, p.LastActivityDate,p.OwnerUserId, p.LastEditorUserId
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 > '2020-07-01'
    and p.LastActivityDate > p.creationDate
    and p.LastEditorUserId <> p.OwnerUserId
/*    and p.Score > 0 */
GROUP BY p.Id, p.title,p.AnswerCount, p.CreationDate, p.Score, p.Tags, t.TagName, v.postid, p.viewcount, p.LastActivityDate,p.OwnerUserId, p.LastEditorUserId

ORDER BY  p.CreationDate DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results